PrintOut Macro

[pauld]

I noticed a lot of posts on how to use VBA to print one page of a multi-page
Report, but I'd like to ask about how to use the MS Access macros instead.

Do I first use the OpenReport macro to open the report in "Print" mode and
then use the PrintOut macro to specifiy pages 1 thru 1 and then use the Close
(Report) macro to close the Report ?

Thanks.

 

[Douglas J. Steele]

You need to open it in Print Preview mode. Opening in Print mode will print
it.

 

[Albert D. Kallal]

I noticed a lot of posts on how to use VBA to print one page of a
multi-page
Report, but I'd like to ask about how to use the MS Access macros instead.

Do I first use the OpenReport macro to open the report in "Print" mode and
then use the PrintOut macro to specifiy pages 1 thru 1 and then use the
Close
(Report) macro to close the Report ?

Thanks.

That sounds about 100% right on.

Your where clause needs no quotes, and will look much like:

[ContactID]=[Forms]![Contacts]![ContactID]