Report problem

L

Lindsay

I created a report that is a purchase order. There is a subform on the
input form where you enter the product information. When I enter the
information and then hit the button to create the report, the product
information shows up many, many times. I could have the same record
fill 4 or 5 pages when it only needs to appear once. Does anyone have
any idea why this is happening? Any help would be greatly
appreciated!!!
 
D

Duane Hookom

You have an issue with the record source of your report or the relationship
between a report and subreport.

You aren't printing a form are you?
 
L

Lindsay

No, Im not printing the report; just viewing it. I think the problem
is that I inserted something in the criteria field of one of the
fields, so that I could only view the report for one record at a time.
But I cannot find another way to do this other than inserting criteria.
I have made other posts regarding this problem and none of them have
worked.
 
D

Duane Hookom

Inserting criteria will not cause "shows up many, many times". Check the
datasheet view of your report's record source to find the issue.
 
Top