How to recover if a user "Undoes" a record?

[David Portwood]

When the AfterUpdate event of my Status field is triggered, I update several
other tables with dependent data. What happens if someone hits ESC twice to
Undo the record? Is there some way I can know that this happened? Then I
could roll back any updates. Btw, the Form_AfterUpdate event doesn't seem
applicable since one of the things I do is set a DateCompleted field on the
form itself. Any ideas or suggestions would be welcome.

 

[Arvin Meyer [MVP]]

You could trap the keystrokes, but it might be a better idea to use the
AfterUpdate event of the form itself to update the other tables. That event
only fires after it's too late to rollback with the ESC key.