Search results

So.... no hopes?

No. With you method I will create multiple reports for each record, instead having all records in A report just different format.

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...

Please, anyone. Even half a clue will do. Thanks.

Put a "Pagebreak" object in the beginning of the subreport2? The one with "..."

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...