Do not display print dialogue box

[Philw]

I am new to Access 2010 and have written a database with a Reports Menu with a series of command buttons each of which prints a report.



These buttons have been produced using the standard design wizard to 'print a report'.

However each of these puts up the print dialogue box to select a printer.

I want these buttons to effectively 'QuickPrint' - i.e. to print to the default printer without putting up the print dialogue b ox.

Does anyone know how I edit the 'on click' macro to achieve this please?

Thanks in anticipation for help.

[June7]

Post your code.

The following will default direct to printer:

DoCmd.OpenReport "report name"

If you want to be explicit:

DoCmd.OpenReport "report name", acNormal