Closing a form without saving

[dirkvw]

Hello,
I have a form to add a record to a table. How can I give the user a way to close this form without saving the just created record.

I tried

If me.dirty then
DoCmd.RunCommand acCmdDeleteRecord
endif

This works, but gives a messagebox in return to confirm the command, and I don't want that. And I try to avoid sendkeys. I also don't want to change the options of access.

TIA
Dirk

 

[jdraw]

Try
DoCmd.RunCommand acCmdUndo
or
Me.Undo

 

[dirkvw]

Thanks jdraw, that's what i needed. (but didn't find!)