Keith Clark wrote:
I have a form which has two subforms connected by the same field in the
main form.
Does it matter in which order I fill in the information in the forms?
Hi Keith,
Well, there is one case in which order matters. If you insert a new
record into the master form then you must save this record before you
can enter data into the related sub-forms, just common sense really.
Something to keep in mind:
Base will auto commit your changes when you leave a control attached to
one form and enter a control attached to another form on the screen.
So - you have a data input form with a Master and two Sub forms.
Enter data into the controls on the Master form and then tab into the
first control on the first sub form. At this point the record in the
master form is saved to the table.
Tab into the first control on the second sub form and the record
attached to the first sub form is saved to the table.
Can I jump form, to subform, back to form, to subform and so on, and
then when I hit New Record on the navigation bar, will Base save all the
information in all the forms to their appropriate tables?
yes that is the idea - keeping mind what I said above however, there may
be no need to write some of the records again.
Do I need to hit the save record button when finishing each
form/subform?
Sometimes. If you entered data into only the master form or only a
sub_form and have not tabbed out of the controls then yes you need to
explicitly save the data.
I ask this because it seems that at times, we are losing the information
on the subforms when we fill them all in, then hit the New Record
button. Not all the time though.
hmm- it shouldn't. The New Record is attached to ONLY the main form?
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
