Pause Subform


J

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top