RunCommand for "escape"

Tim Marshall

What is the docmd.runcommand accmd? for the equivalent of pressing the
escape button when adding a record to a table?

I'm setting up a bound form and would like to have a "cancel" button
that does this.
Thanks in advance.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #1

Larry Linson

Try

DoCmd.RunCommand acCmdUndo

SendKeys "{Esc},{Esc}" works, too. Because it isn't language dependent as
some Menu commands are, it is a more reliable use of SendKeys.

Larry Linson
Microsoft Access MVP

"Tim Marshall" <TI****@antarctic.flowerpots> wrote in message
news:cj**********@coranto.ucs.mun.ca...

What is the docmd.runcommand accmd? for the equivalent of pressing the
escape button when adding a record to a table?

I'm setting up a bound form and would like to have a "cancel" button
that does this.
Thanks in advance.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #2

Tim Marshall

Larry Linson wrote:

DoCmd.RunCommand acCmdUndo

That does the trick, thanks very much.

--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #3