Cancel Edits in form

[Guest]

I work with some dumb user (who doesn't you'll tell me

If it's not written in front of them, they don't know what to do

I'd like to know if anyone knows how to easily perform (in VB so I can attach it to a command button with a user friendly caption) the opposite of "DoCmd.RunCommand acCmdSaveRecord" i.e, cancel all current edits to a record and revert to the original values
I know pressing the ESC key does it, but i'd like do the same with a command button. For now, I have a button with the Cancel property set to True, but that automatically closes the form which I don't necessarily want to do

Any suggestion would be appreciated.

 

[GVaught]

You can create a command button attached to an Undo record event. Use the
wizard to create the command button and look under Record Operations.

I work with some dumb user (who doesn't you'll tell me)

If it's not written in front of them, they don't know what to do.

I'd like to know if anyone knows how to easily perform (in VB so I can

attach it to a command button with a user friendly caption) the opposite of
"DoCmd.RunCommand acCmdSaveRecord" i.e, cancel all current edits to a record
and revert to the original values.

I know pressing the ESC key does it, but i'd like do the same with a

command button. For now, I have a button with the Cancel property set to
True, but that automatically closes the form which I don't necessarily want
to do.