3 Linked Subforms on a Page

[Scott]

I have successfully used the wizard to create a form that
has a subform (datasheet) based on the main form
information, and the second subform displays records based
on the record that has focus on the first subform.

Now I need to add a third subform that displays records
that are based on the fields that have focus in Subform1
and Subform2. The forms Wizard will only go to two
subforms.

Can I link master and child fields from subform to subform?

Any ideas?


Scott

 

[Kelvin Lu]

Access is limited to 3 levels total (Main, subform, sub-subform) when using
bound forms. To go another level you will have to use unbound forms which
may be beyond your experience if you are using the wizard to create these
forms. You will have to think of something else.

Kelvin