Using UndoRecord Command on Blank Form Errors Out

[zcanderson]

Thanks for the help in advance. I am creating my first database for a work project have been able to find my way through most of it but am coming up with an error that I can seem to find an answer to. In my form I have a button to "cancel and return to main menu" if they don't want to save what they entered (this works if data is entered into any field). However if they haven't entered anything and I try to run the UndoRecord command it erros out and will not close the form returning to the main menu. I am using the Macro Builder function and my expression is as follows:





Thanks again for any help.

[June7]

I don't use macros so don't know if this is available. In VBA code could check if the form IsDirty (meaning record has been edited) and only run code if appropriate.

[zcanderson]

Thanks for the reply, updated the code to add "Dirty" function and it seems to work great.