I am keep getting error 2501

  • Thread starter Thread starter Chandra
  • Start date Start date
C

Chandra

I am using VBA script to open a form in update (edit) mode
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

When I complete update and press SAVE button to click on Nevigational bar to
go to next record it saves the changes but also throw error 2501. Form still
remain in "Edit" mode...Unless I press Esc.

How can I change using VB script to mark form in Display mode from Edit
("Pencil") mode?
 
You would be looking for: me.dirty=false to place in the code. This saves
the setting for that record. Esc however is accomplished by me.undo

hth
 
Back
Top