Report (with subreport) creates multiple pages

[mrwog]

I have three tables called tblMain, tblDetail1 and tblDetail2. The detail tables are linked to the main table by field IDNo.

I have a report called rptMain that includes two subreports, srptDetail1 and srptDetail2.

If tblDetail1 contains more than one record with the same IDNo, the report generates as many (identical) pages as there are records in tblDetail1 with that IDNo.

The number of records in tblDetail2 does not cause the same problem.

I created the subreports the same way, and all the properties appear to be the same.

Does anyone have any idea what I should be looking at to fix this?

Thanks in advance.

 

[dhookom]

The main report record source should not include tblDetail1. It should only reference tblMain and any table that might be linked to it Many to One (not one to many).

Duane
Hook'D on Access
MS Access MVP

 

[mrwog]

Thanks! It at least got me looking in the right place and I fixed it.