SendKeys Process

[Guest]

I am presenting the user with a MsgBox containing Yes/No buttons. If they
select No, they are wanting to cancel the transaction. Currently I tell them
in the message to press the ESC key twice to abort the update. I want to
abort the update from within code if they select "NO", but executing two
"SendKeys vbKeyEscape" statements does not seem to work. Any suggestions on
how to totally cancel the update from within code?

Earl Phillips
Volunteer Ex-mainframer trying to learn Access VBA
Harvesters Community Food Network

 

[Douglas J. Steele]

Me.Undo (or is it Me.Undo twice?)

 

[Guest]

A single Me.Undo does the job. Thanks for the help. Every day I learn more.

Earl Phillips
Harvesters Food Network in Kansas City