"Print Report" brings up print dialog

[chestyxbond]

When you use the command button wizard to make a "Print Report" button, how do you get it to bring up the print dialog (that comes up when you go to File>Print) rather than simply printing directly to the user's default printer? We have a large office, and sometimes I may want to print the report to a printer other than my default.

Any ideas?

Thanks,
Daniel

 

[nickjar2]

Hi Daniel,

You could try:
DoCmd.RunCommand acCmdPrint

Let me know if this works for you. Otherwise we can try something else.

Nick