Printing Trouble (1 Viewer)

[GBeck]

most likely another easy fix that has me stumped.
I have a main form with a command button to open a report. Evertything seems to work except that I can't get it it open and display on my cpu, it prints the report directly How do you turn this feature off?
currently I have tried different variations of the the event procedures from the on click. below is what I have currently.
Private Sub NAME_SEARCH_Click()
On Error GoTo Err_NAME_SEARCH_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "rpt offenceslist"
DoCmd.OpenReport "rpt offenceslist", acViewNormal, "", "", acWindowNormal

Exit_NAME_SEARCH_Click:
Exit Sub

Err_NAME_SEARCH_Click:
MsgBox Err.Description
Resume Exit_NAME_SEARCH_Click

End Sub

 

[RuralGuy]

Have you tried:
DoCmd.OpenReport stDocName, acPreview

 

[pbaldy]

If you looked in Help for OpenReport, you'll see there are other options available where you have acViewNormal, such as acViewPreview.

 

[GBeck]

well SOAB I knew it was easy and maybe just from looking at it so long I missed that...
thanks guys, the ac preview works great, not sure what I was thinking

 

[RuralGuy]

Excellent! Glad we could help.

 

[gemma-the-husky]

out of interest, once its open in preview mode, you can right click a report, then save it in various formats, and email it directly (send command). these commands are alkso available from the main menubar

its not immediately apparent that you have this functionality