I tend to use VBA rather than macros, but there should be an UNDO action that
you can run from a macro. That action will erase all changes made by the user
(restoring an existing record to its state when the user opened it, or
removing a new record altogether).