sub, sub reports (1 Viewer)

[Pam Gendron]

I have a need to nest 3 sub reports on one report. It seems Access can only handle two nested sub reports. Does anyone have any ideas as to how to get around this?

 

[Pat Hartman]

There are three options that I can think of off hand. The "correct" solution will depend on what works best with the data you are trying to display.
1. A tab form with a different sub-form on each page.
2. Two sub forms on the first sub-form. If they can't both be linked directly to the sub-form, you can link the "third" form to the second as you normally would and write code to synchronize the "fourth" form so that it only shows data related to the selected row of the "third" form.
3. Add a button to the "third" form to open the "fourth" form.