how to replicate Escape key with VBA

[lorirobn]

Hi,

I have a subform, which is a continuous form. If I start to enter data on the 'addnew' line, then press the Escape key, this erases the data I have just entered.

I would like to replicate this action in my VBA code. If a user attempts to add a duplicate, I give a message, asking if they would still like to add the record. If they enter 'no', I would like to wipe out the data they have started to enter. Currently, the only code I have for 'no' is 'cancel=true'. I tried to add 'me.undo' but this didn't erase the data.

Any suggestions?

Many thanks, in advance.

 

[PHV]

Me.Undo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lorirobn]

Hi PHV,
I had tried me.undo, but it only undoes data in the last field entered, and I'd like to undo data in the rest of the line as well. Escape does that, and I'd like to do that as well.
thanks.

 

[StuckInTheMiddle]

What about using Sendkeys in VBA?

sendkeys("{ESC}")

Check out the VBA help for more info on sendkeys.

A,

 

[lorirobn]

Thanks, Stuck. SendKeys is a great statement to know about, and it did the trick perfectly!

Thanks again.

 

[firefytr]

Hi,

I recommend using SendKeys very sparingly and very carefully. It can be quite a pain in the back side, espescially when debugging/troubleshooting!

-----------
Regards,
Zack Barresse