O
Oden1988
I have a database that uses a main form with 6 subforms in it. In each of
the subforms, I can enter multiple lines of data for each main form record.
However, when I select a new record on the main form, the data in the
subforms (which is linked to the data in the main form) does not change to
new subforms. Basically, I have a name in the main form and each subform
contains different information related to that name. Each subform can
contain multiple entries like phone numbers (a land line, cell, and work
number) all associated with the one name. The other subforms contain
different pieces of info, but all are linked to the name. When I am finished
entering all data in all subforms, I need to be able to switch to a new
record set (new name) and all the subforms need to change as well. AS of
right now, this is not happening. The main form (with the name) will change
, but all subforms do not and what happens is all the data in the subforms
from person 1 is now linked to person 2 as well. How do I get a "fresh" set
of forms to enter new data for another person?
Thanks for any help.
the subforms, I can enter multiple lines of data for each main form record.
However, when I select a new record on the main form, the data in the
subforms (which is linked to the data in the main form) does not change to
new subforms. Basically, I have a name in the main form and each subform
contains different information related to that name. Each subform can
contain multiple entries like phone numbers (a land line, cell, and work
number) all associated with the one name. The other subforms contain
different pieces of info, but all are linked to the name. When I am finished
entering all data in all subforms, I need to be able to switch to a new
record set (new name) and all the subforms need to change as well. AS of
right now, this is not happening. The main form (with the name) will change
, but all subforms do not and what happens is all the data in the subforms
from person 1 is now linked to person 2 as well. How do I get a "fresh" set
of forms to enter new data for another person?
Thanks for any help.