VBA code for Print Dialog box

[scooter]

How do I modify the docmd OpenReport ,,,, so that it
opens the printer dialog box? I want to be able to select
the printer that I print a report to. Currently I am
using the following code and get no dialog box.

DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria

 

[Albert D. Kallal]

What I would do is built a custom menu, and specify it or all my reports.

This is more user friendly, and often the user may NOT want to be prompted
with a printer dialog box.

I have a working sample that allows you to print to your default printer, or
print to a printer of you choice. You can find the working sample here:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

Grab the 3RD link from above called
"click here for access 2000 merge example with ms-access interface
hidden"

When you run it...click on the "sample report (with nice menu bar)"

I find users prefer the above approach where you display the report..and
also display some printer options across the top.

Give the above a try...I think you will like it...