Allow to cancel update on subforms`

[daneharnett]

I have a database that allows users to update data in the tables, i would like the ability to have a 'Cancel' button so that the changes are only committed when the user clicks 'OK' or 'Save'... if the user clicks cancel then the changes should be disregarded...

I can do this easily with 1 form by using the BeforeUpdate Event...

But what about if i have a subform on the form... the data in the subform is saved but the main data would be disregarded?

Any solutions? or other avenues?

 

[FancyPrairie]

You could put the cancel button on the subform, and in the Onclick event of the cancel button do this:

Me.Undo