Report only returns 1 record unless run directly

[teresamichele]

I have a report in Access 2007 that returns records based on a product code. Simple enough, right?

However, I have a form where folks can click "Product Code" and enter the code, let's say 1234, and instead of rptCode coming up with all four entries with that product code, it only returns one.

That said, if I run the report directly, with the same product code, I get all four entries!

I'm guessing, then, that it's the coding or something I've messed up that cuts it off at one. I have no idea what, though.

Any idea what might be causing that?

Here is the code I'm using "on click" for the button:

Option Compare Database
Private Sub Label9_Click()
On Error GoTo Err_Label9_Click
Dim stDocName As String
stDocName = "rptCode"
DoCmd.OpenReport stDocName, acPreview

Exit_Label9_Click:
Exit Sub

Err_Label9_Click:
MsgBox Err.Description
Resume Exit_Label9_Click

End Sub

[ajetrumpet]

whats the recordsource of the report? there is nothing wrong with the code

[teresamichele]

The record source is:

SELECT ProjectEntry.Number, ProjectEntry.Requestor, ProjectEntry.Product, ProjectEntry.Code, ProjectEntry.Test, ProjectEntry.Details, ProjectEntry.[Date Logged], ProjectEntry.[Date Due], ProjectEntry.Status, ProjectEntry.Person, ProjectEntry.[End Date], ProjectEntry.Priority, ProjectEntry.[Kronos], ProjectEntry.[Start Date]

FROM ProjectEntry

WHERE (((ProjectEntry.Code)=[Enter Product Code]));

Like I said before, though, it works fine if I just click on it from the list of objects, but if I run it from the button on the form, it stops at one record. I'm quite confused!

[RuralGuy]

PMFJI but you can get different results for Preview vs. Printing. I know it is a waste of paper but do you get the same results when printing from the form? I prefer to provide the Control on the form for the Criteria rather than forcing the query to ask the question and then use the WhereClause argument of the OpenReport command to apply the Criteria. Just my $0.02