Just a small shout!!

[IanHem]

How come its so hard to create an undo method when using a form and subform, lookup tables and tiered selections in combo boxes?

 

[spikepl]

Moses decided this issue on his tablet so blame him

update: whining is a totally pointless activity. focus rather on how to resolve or bypass issues

 

[CJ_London]

what's wrong with using the esc key?

 

[IanHem]

I've answered my own problem here.

Thanks CJ but escape doesn't work if you have a subform and move focus to that because Access autosaves at this point.

I had an SQL statement which created temporary tables to store the original information (Thee User is editing here).
Then on undo another statement to re write the changes. The problem with having lookup tables was resolved by simply saving the record before performing any SQL.