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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subreports repeat in the main form

Status
Not open for further replies.

Pack10

Programmer
Feb 3, 2010
495
US
I have a country report which contains several subreports. The subreports essentially are sections of about 10-20 fields.
So, I have the first 10 or so questions followed by 6 subreports. In testing the report, I notice that the subreports are duplicating. For instance, the section 3 subreport will display, then there is a blank page, then the subreport displays
agsin, then the next section or subreport displays it's 15 or so fields, then repeats itself again.
I don't understand what's happening. Can anyone help me understand how to fix this.
 
Can you explain your report further? From what you wrote I believe each sub report is showing for every record? Is it possible to put the sub fields in the main report?
 
If you have duplicated subreports appearing, it typically means the higher level report's record source contains a child table that should be removed. If you can't figure this out, you should provide the record sources of your reports, the relationships between your tables, and the link master/child properties of your subreport controls.

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top