problem printing multiple pages

J

john oorej67_7

i have a report with a subform attatched each time i print this report i get 4 copies.
ive got 1 record in the main report and 4 in the subform, both have id fields linking them on theyer respected tables and on the report, basicly its printing x pages for x records in my subform. can any one point me in the right direction to stop this from happening???

thanks in advance
 
D

Duane Hookom

It sounds like you have your detail records included in your main report.
For instance, if you have a table of Parents and a table of Children, your
subreport would contain the children records and your main report would
contain parent information (no children allowed).

--
Duane Hookom
MS Access MVP


john [email protected]> said:
i have a report with a subform attatched each time i print this report i get 4 copies.
ive got 1 record in the main report and 4 in the subform, both have id
Click to expand...
fields linking them on theyer respected tables and on the report, basicly
its printing x pages for x records in my subform. can any one point me in
the right direction to stop this from happening???
 
Top