Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Same Subreport Repeated 100 Times

Status
Not open for further replies.

TZyk2003

Programmer
Jun 17, 2003
33
US
Hello everyone!

I have created a report with ONE subreport. The subreport has it's own query and no fields are linked between the main and sub report. Now, when I go into the subreport and do a Print Preview the correct 1 page report is shown.

However, if I go back to the main form and Print Preview the report from there, the correct results are shown except that 1 page is repeated 107 times! So, what should only be one page turns out of the 107 pages of the same report, over and over again! Anyone know how I can just get that 1 page to display??

Anyhelp would be GREATLY appreciated! If you need me to clarify - let me know. THANKS!

-Tim

PS- I have to keep it as a subreport since once I get this subreport working I have to add additional ones to the main report.
 
Your main report probably has 107 records. I assume this is not what you want.

Duane
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top