DoCmd.DomenuItem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Error 2237 8
acEditMenu help 1
Msgbox problem 4
"Delete Record" command button woes 4
Button to delete record on datasheet subform 5
Command Button not working on form - HELP!!! 3

Back
Top