DoCmd.DomenuItem

F

Flemming

Hi,

This is failing with code 2065. Can you help?

DoCmd.DoMenuItem acEditMenu, acSelectRecord, acDelete, acMenuVer70

I am using this on exit of a field. If the existing information already is in
the database then select what has been typed into the field and delete
the typing and cancel the move (enter).

Thank you.

Flemming Ast
 
J

Jeff Boyce

Flemming

Consider using a BeforeUpdate event to determine the presence, then
DoCmd.Undo
to undo the entry.
 

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

Answer "Yes" when delete a record 1
vba coding 4
Copy Record Date Won't Copy 0
add one to a duplicated record that checks to see if one exists 0
Error 2237 8
acEditMenu help 1
Need to fix .DoMenuItem for Access 2007 1
Msgbox for "Nothing to Delete" 7

Top