B
BJ
I received the idea last week from this group that I could establish a
parent-child relationship between forms that were not physically
located on one another. I cannot make any of the prior suggestions
work so I'm trying again.
I have three forms, each built on a corresponding table (3 tables),
forms A, B and C. I want to set up B as a child of A and C as a child of
B. I would like both B and C to reside in the detail section of A. That
places B in exactly the position that Access normally seems to like, and
B and A work fine (so, when I change records in A, the corresponding
records in B appear on subform B). I would like C to behave in exactly
the same manner but I don't want it to reside on B. I have tried the
folllowing syntax in the master and child links for C (for ease, the
control name and form name for each of these forms/subforms are the
same):
master field: forms!frmA!frmB.form!ID_frmB
child field: ID_frmB
It doesn't work. No matter how I code the references (for example, I
have tried using full references in both child and master links), when I
open frm A, it cannot see the controls on C and C cannot see the
controls on B.
Moreover, there is an automatic requery that occurs when a subform
resides on its parent. I have tried to force a requery of C on the
Current event of B. No luck.
Another try: On Jonathan's advice (thanks Jonathan), I tried an unbound
control on C that references the master field on B. No dice.
I have tried to see what Access does with a child-resting-on-parent
subform, but Access exposes little more than the names of the linking
fields.
Has anyone had success doing this before? Any help?
parent-child relationship between forms that were not physically
located on one another. I cannot make any of the prior suggestions
work so I'm trying again.
I have three forms, each built on a corresponding table (3 tables),
forms A, B and C. I want to set up B as a child of A and C as a child of
B. I would like both B and C to reside in the detail section of A. That
places B in exactly the position that Access normally seems to like, and
B and A work fine (so, when I change records in A, the corresponding
records in B appear on subform B). I would like C to behave in exactly
the same manner but I don't want it to reside on B. I have tried the
folllowing syntax in the master and child links for C (for ease, the
control name and form name for each of these forms/subforms are the
same):
master field: forms!frmA!frmB.form!ID_frmB
child field: ID_frmB
It doesn't work. No matter how I code the references (for example, I
have tried using full references in both child and master links), when I
open frm A, it cannot see the controls on C and C cannot see the
controls on B.
Moreover, there is an automatic requery that occurs when a subform
resides on its parent. I have tried to force a requery of C on the
Current event of B. No luck.
Another try: On Jonathan's advice (thanks Jonathan), I tried an unbound
control on C that references the master field on B. No dice.
I have tried to see what Access does with a child-resting-on-parent
subform, but Access exposes little more than the names of the linking
fields.
Has anyone had success doing this before? Any help?