Cancel changes in subform

[tommeekers]

I have a form which I use to edit data. This form also contains a subform with some more data, linked to the main form. On the main form I have the buttons "Save" and "Cancel".

When I press "Save", my data is saved and the form is closed. When I press "Cancel", all changes are cancelled and the form is closed. This works for the main form because I use Me.Undo before closing, but the changes in the subform are always saved. Any way to cancel those changes also ??

 

[Remou]

Perhaps:
[tt]Me.[Subform Control Name].Form.Undo[/tt]

 

[tommeekers]

I wish it was that simple.
But it seems as soon as I leave my subform (by pressing the button on my main form), the data on the subform gets saved. And I cannot undo saved changes with the Undo command.

 

[tommeekers]

Perhaps I should have mentioned that my subform is displayed as a datasheet. I'm adding / editing records directly on the datasheet.

 

[tommeekers]

Anyone found a solution for this yet ? I'm still having problems with it.