subform to subform

[JohnE]

Grreetings.
I have a main form that on it I would like to either place a subform with a
subsubform on it or instead place 2 subforms. What I am attempting to
accomplish is to have one subform (B) dependent on the other subform (A)
which is dependent on the main form. It is a drill down process. An example
would be the main form is the client, subform A are its offices, and subform
B are jurisdictions each office manages. It would be good if each subform is
a continuous form. If so, then a button could be placed at the beginning of
each record on subform A that would show its respective jurisdictions in
subform B.
It is giving me nightmares as to how to go about getting it all to work
properly. So I am asking for assistance in how to proceed in getting the 3
properly connected to work properly. Most of it I can get but getting the 3
to sync properly is my dilemma.
Thanks for any assistance.
***John

 

[Allen Browne]

Open the Northwind sample database.
Open the Customer Orders form.
Examine the LinkMasterFields and LinkChildFields properties of the subforms,
to see how to create a form that has connections like that.

The first form also has code in its Current event.

 

[JohnE]

Allen, thanks. That should do the trick.
*** John