I have a Main report in my database with two Subreports ("Level" and "Quality"). Each (sub)report is based on a different query, but all queries include the same field ("Location") from the same table and it appears on each (sub)report for debugging purposes. This field is the Master/Child link.
I have run each subreport independently (both have controls only in their Details section), and they function well (the report repeats for each Location).
The "Location" field is displayed in a bound text box the Detail section of Main (which is grouped by a different field from the Main query). Both subreports also appear in the Detail section.
I would like my report to show:
~~~
"Location"
Level Subreport for that Location
Quality Subreport for that Location
~~~
for each Location (the ~s are meant to separate the report appearance from my question). What currently appears is:
~~~
"Location"
Quality Subreport for that Location
Quality Subreport for the next Location, etc.
~~~
where etc means that Quality Subreports for all locations are shown for each location in the Main report. The blank line between "Location" and the first "Quality Subreport" represents that the Level Subreport does not appear (nothing of its skeleton and nothing of its controls).
Additionally (I mention this only in the hopes that it helps the trouble shooting), I have a rectangle around the Detail section of Main. The extra Quality Subreports appear below the rectangle, something like (except that the vertical edges actually line up, this does not happen when this message posts, sorry):
~~~
__________________________________________________
| "Location" |
| |
|___Quality Subreport for that Location __|
Quality Subreport for the next Location, etc.
~~~
The Format and Data for the subreports are identical apart from the Record Source.
I've been working on this issue for a couple of days. I'm presenting the database tomorrow and I'd like to have this report working by then.
This is my very first forum post and I am new to Access so I apologize for the funny notation. I don't speak much VBA or SQL, so I hope that solutions aren't too complicated.
Many thanks for all help.