Synchronizing nested subform on tab pages with main form

  • Thread starter Caburky via AccessMonster.com
  • 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!
 
R

Rick Brandt

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!

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.
 
C

Caburky via AccessMonster.com

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
[quoted text clipped - 4 lines]
Thanks in advance!

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,
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.
 

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