print dialog

[icccapital]

Is there any good way to bring up the print dialog one a user defined print
button. I would like to give the user the ability to change the printer to
use for a print job and then run my code for what to print. I am currently
using microsoft commond dialog 6.0 on my form and it works fine in the
development environment, but when I went to install on a user machines I got
"there is no object for this control", which I read is a common dialog
problem.

So is there another way or a solution to this problem that I am missing?
tHanks

 

[Jim Burke in Novi]

If you bring up the report in Print Preview mode, they can choose File,
Print... from the menu bar to change the printer, e.g.

DoCmd.OpenReport "reportName", acPreview

 

[icccapital]

Thank you for the reply, actually the code behind the print loops through a
specific set of clients and prints only their reports so I need the printer
decision to be made once before the print job starts.