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

"Jake" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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