Print more than one main record

  • Thread starter Thread starter rob p
  • Start date Start date
R

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.
 
Yes. The Main Record has a field that matches one on subrecord. When
displaying main record, only subs with match show up in subrecord.
 
Then if you select the table as the record source instead of the query that
*should* print all the records properly....

Neil.
 
Back
Top