Common Undo

[fileman1]

Is there a way to have an Undo button on a main form that will undo the main form and any sub forms? I think if you move off a form to another, the data gets saved, might be wrong? Is there an easy way to get round the problem? Thanks

 

[jeffwest21]

The only way i found to do this is to have some hidden text boxes holding the original data as the data is changed, then if you click undo it just reloads this back into the boxes, however the issue with that is getting round the fields being bound to a table field. I got round this by not binding them to the fields. but hjaving them populated at runtime, this will depend however on how you are populating them in the first place.

'Clever boy...'

 

[fileman1]

Thanks Jeff, I was also thinking of using the oldvalue method. Wish now I had done everything unbound. Never mind, maybe one day in the future a version of Access might offer something. Thanks again