Opening Forms from Subforms

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
 

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