why is this code Printing instead of opening the report

[JOWINO]

DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'"

 

[theDBguy]

Welcome to AWF!

DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'"

Try using acViewPreview instead of acViewNormal.

 

[Ranman256]

the default NORMAL means print. (i wish it was the other way)

 

[Gasman]

DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'"

Ever considered looking up the syntax?

DoCmd.OpenReport method (Access)

Office VBA reference topic

learn.microsoft.com