Printer Dialog in Access

[dragonmanUSMC]

Greetings, I need to know how to get the printer dialog window to open when a button is pressed to print a window. Right now, when you go to print a report the default printer automatically begins printing and when I select a specific printer that will automatically begin printing as well.

Any help will be appreciated.

 

[RoyVidar]

Do you have a button in a report?

You can use the code

[tt]docmd.runcommand acCmdPrint[/tt]

Roy-Vidar

 

[dragonmanUSMC]

Thanks for the reply, the button is on a form that calls a report to print

 

[dragonmanUSMC]

Thats close to what I need but it is wanting to print all the records.

 

[RoyVidar]

Also if you place it in the reports on open event?

Roy-Vidar