Rollback of data in a bound subform

[mrk68]

Hi,

I have a sub-form bound to a query. Since it is bound as soon as I tab out of the control, the data gets updated. If I have to rollback this or cancel the updates, how do I do it. Can I use transactions to rollback changes done in the subform, if one of the fields is empty in the main form ?

Thanks in advance,


mrk68

[RuralGuy]

The only solutions that I've seen that work are either using a temporary table for the SubForm or not allowing entry into the SubForm until the MainForm has been completed and verified.

[mrk68]

I have used a Cancel button to undo (based on current date) any edits done to the table by the subform.

mrk68

[RuralGuy]

And this works for you?