I am keep getting error 2501

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?
 
M

Maurice

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run time error '2001' You cancelled the previous operation 2
write conflicts 1
Error Code 2046 1
Clear a form 1
Refresh form to show information entered via a popup 12
Code error when opening a form 2
vba coding 4
Error: SaveRecord isn't available now (urgent) 7

Top