Synchronizing nested subform on tab pages with main form

  • Thread starter Thread starter Caburky via AccessMonster.com
  • Start date Start date
C

Caburky via AccessMonster.com

I have a nested subforms on a tab pages. Both the parent form and the
subforms have an ID number that I have linked parent/child. This works fine
if a record already exists. My question is this: If I set the parent form
to go to new record on open, how do I set the nested subform to synchronize
with the new ID number? *The ID field on the parent form is autonum.

Thanks in advance!
 
Caburky said:
I have a nested subforms on a tab pages. Both the parent form and the
subforms have an ID number that I have linked parent/child. This
works fine if a record already exists. My question is this: If I
set the parent form to go to new record on open, how do I set the
nested subform to synchronize with the new ID number? *The ID field
on the parent form is autonum.

Thanks in advance!
Click to expand...

How have you "linked parent/child"? Did you use the MasterLink and ChildLink
properties of the subform control? That is how you synchronize subforms to
their parent form and that automatically takes care of existing and new records.
 
Rick said:
I have a nested subforms on a tab pages. Both the parent form and the
subforms have an ID number that I have linked parent/child. This
Click to expand...
[quoted text clipped - 4 lines]
Thanks in advance!
Click to expand...

How have you "linked parent/child"? Did you use the MasterLink and ChildLink
properties of the subform control? That is how you synchronize subforms to
their parent form and that automatically takes care of existing and new records.
Click to expand...
Rick,
Thanks for the reply. Sorry I didn't get back earlier I became ill and need
a few days bedrest.

Back to the form. I do have the MasterLink and ChildLink properties of the
subform control set. I believe I'm encountering the problem because they are
nested subforms on tab pages. Each tab contains a subform linked to
different record source, therefore I have a need to synchronize all when you
move to a new record. Currently, when I attempt to go to a new record (the
parent id number is an autonum), the subforms do not display. I'm at a loss.
 
Back
Top