Print or Review

[Martin Hopkins]

Hello,

I have a report that is run by a marco from a form using the crireria that
the user enters. All works very well and the report goes direct to the
printer.

But on some reports I need to ask the user if they wish to print or preview
the report.

How is this done through a macro or form?

Any help gratefully received

Martin Hopkins

 

[John Vinson]

How is this done through a macro or form?

The simplest way would be to have a Form with two buttons, one of
which opens the report in Preview mode, the other in Print mode. I
don't use Macros so I'm not sure of the syntax, but in VBA code it
would be

DoCmd.OpenReport "reportname", acPrint

or acPreview respectively.

John W. Vinson[MVP]