ESC Key in VBA (1 Viewer)

[JimMiller]

Does any one know how to code the action of the ESC Key in VBA? The specific action I am looking for is when a record that is being updated is canceled out of.

 

[Rich]

Use Me.Undo it's more reliable.
HTH

 

[JimMiller]

Rich..thank you for your reply! When I use Me.undo I get the following:

Run-time error '3020', Update or CancelUpdate without AddNew or Edit

Does this mean I must have a record inserted before I undo it...

 

[JimMiller]

I relize that me.undo is more reliable, but do you know the VBA code for the ESC key?

 

[Rich]

You can only Undo newly added/edited records, the same applies to ESC. Please explain what your trying to achieve.

 

[JimMiller]

Rich...thanks for all your help! I figured it out.

 

[suy]

If you use the SendKeys instruction with {esc}it also works - although I don't think this is "professional" coding.