Need to open report from a command button (1 Viewer)

[msiren]

If I use the "docmd openreport" it prints the report. I just want the command to open the report and then let the user decide to print or not print. Is there a preview command that I could use?

 

[Carol]

Make a Preview Button and on the On Click - Event Procedure use this code for previewing the report only.

Private Sub Preview_Click()

PrintReports acPreview

End Sub

The user can always print from the preview if required.
(Subject to any custom menu bars attached to the report)

Hope this helps.

[This message has been edited by Carol (edited 02-10-2000).]