subreports print multiple times

[pbuethe]

I had this problem before with a different set of reports, but forgot what I did to fix it. I have a report with 5 subreports. The report is printing 3 times i.e. I have 39 pages when I should have 13. The report prints through 3 times. I hope you can help!

 

[pbuethe]

Oh well, I posted a little too soon. I fixed it by removing the record source of the main report. There were 3 records in the table that was the record source, so the report was printing 3 times. There was one field displayed in the header of the main report that was in that table, but I got it by creating a query to get that field, then creating a Dlookup in the report.