Print more than one main record

[rob p]

Main report has 3 records. These are 3 vendors . Subreport consists of 3
records each for the 3 vendors in the main report.

When I look at vendor1, I can see the 3 subrecords that belong to this
record. Same with vendor2 and vendor3.

I put a print button on the main form. Only the current vendor and it's 3
subrecords will print at a time. I want each vendor (3) to print, one each
to a page.

By the way, query for report I made looks for vendor. It picks up current
one and prints it with the 3 records on one page. I want the other two also.
If I take this out then I get all the records with no grouping.


thanks. Hope this makes sense.

 

[rob p]

Yes. The Main Record has a field that matches one on subrecord. When
displaying main record, only subs with match show up in subrecord.

 

[Neil]

Then if you select the table as the record source instead of the query that
*should* print all the records properly....

Neil.