Report with subreport printing multiple pages

[accessuser23]

Hi!
I've looked on many websites for a solution for this but havent found the right one yet. I'd appreciate any help.
I have a table that stores various information for specific dates, and shifts.
I have another table that stores notable events for each date and shift.
I have a query that pulls together all the information from the first table based on the selected date (the query filters this).
I have another query that pulls a report of all notable events for a specific date.
I created a report with the main detail section pulling information from the 1st table and query. This works fine by itself.
I created a subreport in the report footer section and linked the second query to this subreport.
My hope is to select a date and have the main report pull all the relevant information for the specific date from the 1st table, and the subreport to pull all the info for the same date from the 2nd table/query.
When i run the report, i get 3 copies of the report; there are 3 entries in the second table (which feeds the subreport).
can someone please help? Is there a VB code that i can use to ensure that the main report and subreport just print once?

Y

 

[GinaWhipp]

Sounds like it's the RecordSource of the reports with the problem You need to look at those, fix them and your report should be fine.