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 - 31 Mar 2005 22:09 GMT
Hi Brian
did you change anything in your table after you created the report?
KB
Brian_G. - 31 Mar 2005 22:13 GMT
Correction to the question: I am printing a report with an embedded subform.
> 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
[quoted text clipped - 10 lines]
>
> Thanks for the help.
BabyATX13 - 31 Mar 2005 22:40 GMT
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
BabyATX13 - 31 Mar 2005 22:24 GMT
Brian,
Check to see if your tables have the correct relationships in your query
this may be the problem.
KB
Brian_G. - 31 Mar 2005 22:31 GMT
Thanks. I'll check this out.
> Brian,
> Check to see if your tables have the correct relationships in your query
> this may be the problem.
> KB