Report Printing Automatically Issue

[The Merg]

I have a Form that when a button is pressed, it performs the DoCmd.OpenReport
command. Whenever the report is opened, it automatically prints. I am racking
my brain trying to find what setting I changed to have this happen and am
having a complete brain fart on this. I have even created a brand new report
and the issue is still there. I know the fix is simple, but I can't remember
where this setting is.

Thanks,
Merg

 

[Clifford Bass]

Hi,

Use the acViewPreview setting:

DoCmd.OpenReport "rptMyReport", acViewPreview

Clifford Bass

 

[The Merg]

Yeah... I knew it was going to be something that simple. Been a while since
I've worked in Access...

Thanks,
Merg

 

[Clifford Bass]

Hi Merg,

You are welcome!

Clifford Bass