How to control saving a new record

[Tariqzkh]

Dear all,

I have a form were I need the user to choose between two buttons to either save or cancel the filled record details.

I don't have that much experience with coding so hope to get your help.

 

[Velosai]

If you create two command buttons, on the save one, you just close the form normally or whatever you wish to do, then on the other one, you use DoCmd.SendKeys {Esc}{Esc} then it will cancel the changes carried out on that record.

 

[Rich]

Me.Undo is preferable over send keys