A
alicia
I must be going crazy.
I have a form with 2 subforms. Main Form = Form A,
Subform1 = B, and Subform2 = C. Form A links to B which
links to C.
With success, I have added a command button on B to open
another form which updates additional tables where the
unique ID for B carries to the new form. In doing so, I
had the use the [forms]![FormA]![FormB].[Unique ID].
Now I need to do the same with FormC. I need to open
another form that relates to the Unique ID in Form C and
just need to pull the Unique ID forward to this new form.
I tried (based on what worked in the above paragraph)
[Forms]![FormA]![FormB]![FormC].unique ID.
I cannot get the last form to open with the unique ID
from FormC. It looks like Access stops at the first step
of [Forms]![FormA].
I have tried to eliminate the forms A and B in the syntax
with no success.
Does Access get confused when dealing with a subform of a
subform. OR am I just confused. Thanks! Alicia
I have a form with 2 subforms. Main Form = Form A,
Subform1 = B, and Subform2 = C. Form A links to B which
links to C.
With success, I have added a command button on B to open
another form which updates additional tables where the
unique ID for B carries to the new form. In doing so, I
had the use the [forms]![FormA]![FormB].[Unique ID].
Now I need to do the same with FormC. I need to open
another form that relates to the Unique ID in Form C and
just need to pull the Unique ID forward to this new form.
I tried (based on what worked in the above paragraph)
[Forms]![FormA]![FormB]![FormC].unique ID.
I cannot get the last form to open with the unique ID
from FormC. It looks like Access stops at the first step
of [Forms]![FormA].
I have tried to eliminate the forms A and B in the syntax
with no success.
Does Access get confused when dealing with a subform of a
subform. OR am I just confused. Thanks! Alicia