Report keeps repeating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has sub-reports but for some strange reason the report
keeps re-printing the entire report for each section in the sub-report.
The report gets generated via a form where the criteria is selected .Please
help
Natasja
 
Access Africa,
Not much information to go on, so I'm assuming a very basic cause...

Sounds like you have included/related one of the subform tables into the Main portion
of the report causing duplicate propogation.

Given that your report tables that are related One to Many...
Ex. Customers (One) and Purchases (Many)
The Main report should be based on the ONE Customer table, and the subform/s on the
MANY Purchases table.
(linked on the report via the Parent/Child property, using your key field (ex.
CustomerID))
 
Make sure that your subreport is sorted on the field(s) you are using to link
to your parent report by, and that you are properly using Link Child Fields
and Link Master Fields properties.
 
Back
Top