Printing report WITHOUT viewing it

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hi

I wish to print the contents of a report by pressing a button on a form
WITHOUT viewing the report on screen

Could somebody advise me of the code which I need to add to the click event
of my form's button in order to do this?

Many thanks

Jake
 
Just use
DoCmd.OpenReport "Your Report Name", acViewNormal

Please see help file for OpenReport method. There are more option parameters
you may use.

HTH
 
DoCmd.OpenReport "<Report Name>", acViewNormal (follow with any filters here)

acViewNormal is the default so it is not necessary to type it. To view use acViewPreview

Baz
 
Back
Top