Undo changes when record has been refreshed

[mcucino]

Hi all, I am trying to think of a straightforward way to revert the record on a single form to the original values from when it was opened. Normally, this is very easy with the undo command, but there are a lot of after update events for each field that refresh the data so the record isn't dirty. Aside from an on load event that stores each field as a variable and reverts it back upon clicking undo, is there an easy way to do this?

[Micron]

IMHO, if it's not simple because of the potential record saves (some of which can't easily be undone or prevented, if at all) then consider a temp table. Use a query to load records into the temp and base the form on it. If you want to keep the results, you update the primary table. You need to consider the potential for concurrent users on the same record trying to apply updates. If this is a multi user situation, you have of course split the db, so the temp table(s) need to be in the user's fe copy. Note that I'm not talking about continually deleting/re-creating a table when I refer to temp table.