forms question

[David]

I have a form designed that takes multiple records for a given ID and prints
the information for each record on the form, and does this for each ID in a
table. The problem that I have is that it prints only one page per ID,
truncating the data if there are more records than fit on one page. How do I
set it to print as many pages as are necessary for each ID, then start fresh
with the next ID, and so on?

thanks,
David

 

[Arvin Meyer]

I have a form designed that takes multiple records for a given ID and prints
the information for each record on the form, and does this for each ID in a
table. The problem that I have is that it prints only one page per ID,
truncating the data if there are more records than fit on one page. How do I
set it to print as many pages as are necessary for each ID, then start fresh
with the next ID, and so on?

Use a report/subreport instead of a form/subform for printing. You can base
them on the same design and the same query. Set the subreport's CanGrow
property and the detail section it's in on the main form to Yes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access