3 Linked Subforms on a Page

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
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
 
Back
Top