Report repeats 35 times
I have designed a simple database to manage the publication of a weekly list of events. One report I have designed has two (2) sub-reports and prints in 2 columns on one A3 page - This week's events and featured future events. I have used a parameter form to set the date ranges for both sub-reports. When I run the report, it shows up 35 times.
I have another very similar report using exactly the same queries and parameter form but printing on A4 paper. It is made up of a base report and a sub-report and it prints once and usually stretches to 2 pages. I could not get the A3 report to print on one page when I tried the base report and one sub-report so went to 2 sub-reports to get it to work. It works fine but shows up 35 pages. I am just printing page 1 and everything is good but it is very annoying. Any ideas on where I should start looking for the problem.