OldValue

Scenerio: I have a command button: "Clear and Cancel All Edits" on a subform.

They want to be able to clear all edits on that subform that they just made and have all the fields go back to their original value. I have many bound fields on this form, so I really would like to find code that I won't have to list all of them and use the OldValue command. So I am hoping it can be done with the form in general...or something along those lines...unless someone has a better idea.

I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…