Pause Subform

[jschping]

Hi,

I have a main form with a bunch of subforms. Each subform is built on its
own query. Each subform has a combo box that is bound to a field in the query.

What happens is that if I change a value in one combo box (in one subform)
then go to a control in another subform, the first subform already commits to
the table! The value is saved. If I hit ESC, the new value is still there.

I want to have a SAVE button and CANCEL button at the bottom of the main
form, so the user can undo all their changes to the main form and all the
subforms. How can I do that if the subform already committed the changed
value?

Thanks!!

John Schping

 

[jschping]

Hi,

How would you suggest redesigning the form? I have separate queries for each
subform since I'm working with related tables, and one-to-many relationships.
I can't put it all in one form, unless I am missing something.

Please help!

Thanks so much,

John Schping