Open Print Dialog when Report is opened

[tylerg11]

Hello,



When I open a report to print it using acViewNormal (which prints out right away). I want the print dialog to pop up allowing me to make some changes (paper tray to use, etc.) before it actually prints out.

Any ideas?

[rpeare]

try using this:

DoCmd.RunCommand acCmdPrint

I've seen this work with print preview, you may have to mess with it to try and send something directly to a printer