Coming up blank.

[pwicr]

When I double click the report and open it manually, the report comes up fine...except it comes up for ALL 9500 records. When I use the button on the form (which used to work fine) to print the report for ONLY the CURRENT record, I get a blank.

Here is the code for my button

Private Sub btnPWMSO_Click()
On Error GoTo Err_btnPWMSO_Click

Dim stLinkCriteria As String

If Me.Dirty Then Me.Dirty = False

stLinkCriteria = "[Serial Number] = " & Chr(34) & Me![Serial number] & Chr(34)
DoCmd.OpenReport "rptPWMSO", acViewPreview, , stLinkCriteria

Exit_btnPWMSO_Click:
Exit Sub

Err_btnPWMSO_Click:
MsgBox Err.Description
Resume Exit_btnPWMSO_Click
End Sub


and the attached is what it looks like.

 

[pwicr]

here is what it looks like when I double click the report and it comes up with all 9500 records.

 

[pwicr]

When i delete the two text boxes that are coming up in the first attachment as Error and Type, it still comes up blank.

The one that comes up Error is =[enter sticker weight]
the one that comes up Type is =Trim([MODEL] & "-" & [SERIES])

 

[pwicr]

UPDATE!

It originally wasn't generating because it didn't like the way the query was set up.

Got that fixed...BUT...now it generates for SOME records and not others. I can't seem to find any correlation to the records. It isn't a certain customer, isn't a certain model. Any suggestions?

 

[pwicr]

Ha! Got it! So happy!!!