Run-Time error 3075 with open report (1 Viewer)

[falcondeer]

Hi everybody,

I need some help plz,

I have the attached form.
I get run-time error 3075 (attached) when I click on print when the form is empty like in the pic.
The code under click event is the following:

Private Sub Print_Click()

Dim strReportName As String
Dim strCriteria As String
strReportName = "rptWA"
strCriteria = "P_ID= " & Me!P_ID
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub

Appreciate any help.

 

[theDBguy]

strCriteria = "P_ID= " & Me!P_ID

Hi. Try changing the above to this.

strCriteria = "P_ID= " & Nz(Me!P_ID,0)

 

[falcondeer]

Hi. Try changing the above to this.

strCriteria = "P_ID= " & Nz(Me!P_ID,0)

OMG, thanks a million.

 

[theDBguy]

OMG, thanks a million.

Hi. You're welcome. Good luck with your project.