Printing multiple copies of a form

[Guest]

Hello. I'm trying to troubleshoot why a form I designed is printing multiple
copies (an entire report for each record) instead of one when I hit the
<print> button. So, when I have 70 records in the subform, the report will
print 70 times instead of only once. I have read the other questions and did
not see anything resembling this problem.

The subform is based on a simple query from a table and does not include any
relationships. The property is set to single form view, and the 70 or so
records fill up 5 pages in one printing.

I can temporarily remedy this by choosing the number of pages and copies to
print but would like to be able to skip this step.

Thanks for the help.

 

[BabyATX13 via AccessMonster.com]

Hi Brian
did you change anything in your table after you created the report?
KB

 

[Guest]

Correction to the question: I am printing a report with an embedded subform.

 

[BabyATX13 via AccessMonster.com]

Brian,
Check to see if your tables have the correct relationships in your query
this may be the problem.
KB

 

[Guest]

Thanks. I'll check this out.

 

[BabyATX13 via AccessMonster.com]

Brian_G. Wrote

Correction to the question: I am printing a report with an embedded
subform.


Brian,
Do you mean you are printing a report with an embedded subreport?
If so let me look some more, I?ll see what I can find.
KB