help with vba issue

[bigmac]

hi all, I am running the following code
Private Sub SearchResults_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "monthly report"

stLinkCriteria = "[record id]=" & Me![searchresults]
DoCmd.OpenReport stDocName, , , stLinkCriteria
End Sub
to try to open a report to view but it just sends it to the printer, what am I doing wrong please? cheers

 

[missinglinq]

Try

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

or

[B]
DoCmd.OpenReport stDocName, acViewReport, , stLinkCriteria[/B]

With acViewPreview you can right-click and hit Print.

Linq ;0)>