I am not sure if I got your wordings right... with you question I would say I want to have a different subreport for each records.
Lets put it this way (probably easier... I guess)
Recordset has 10 records
ID TYPE
1 1
2 2
3 1
4 3
5 1
6 3...
Hmm...
I run the Query in the main report (which has nothing BUT 3 x subreports + 2 x textboxes - textbox1 holds value of "ID" and textbox2 holds value of "TYPE").
For each record it reads in, I populate the textbox ("ID", as well as the "TYPE" ) and the ALL 3 x subreports will populate...
Hi all,
New to here, new to access too. I only seriously develop stuff in Access since less than 2 weeks ago.
One of the report I have developed (its on live now) is PAINFULLY slow. So I want better solution with it. Its not super urgent but would be nice if I can improve it ASAP...