Open a form in Edit mode using VBA

**jeskit** · 04-18-2012, 11:00 AM

Hi

Can anyone figure why when I open a form in Access 2007 using VBA code, it will not allow the record to be edited?

I have two forms. The first one, which is a split Form, and the second one which is a datasheet. I have added a button on the first form so that when selected it will run the code which displays an inbox so the user can enter a ID number, then it opens the second form and filters the form to show only the id number entered. However when the form opens the records in it can not be edited. The code I am using is below:

Please Login or Register  to view this content.

I have checked the properties of the second screen and there is no record lock, and the permissions are set to allow edits. Is it because I am filtering the data?

Can anyone help??

Thank you in advanced

Jeskit

**split_atom18** · 04-18-2012, 03:12 PM

Hi Jeskit,
Is it telling you the record is not updatable?

Check form properties: Format Tab - Allow Edits = Yes

Please Login or Register  to view this content.

Check the record source by itself to see if it is updateable.
Click the ... Button next to record set which opens the query builder
Change the view to datasheet. See if you can update a record there. If not it is an issue with your recordsource.

Hope this helps,

Dan

**jeskit** · 04-19-2012, 03:55 AM

Hi,

I have checked the properties and Edits are allowed, I have checked the record source and its update-able. I find when I open the form without filtering the data it allows edits but then when I filter it it stops allowing edits.

thanks for your help

**jeskit** · 04-19-2012, 04:04 AM

Hi

I have figured it out! On the first form I had a record Lock on All Records, so I changed that to No Locks and put no to Allow Edits. Its all working now.

Thank you for all your help split_atom18