Open Report from VBA without it automatically printing

[Johnny Drama]

Hello all,

I'm trying to open a report in Access 2007 through VBA, but whenever I try to open it in Normal view it just automatically sends it to the default printer. It works fine in preview and I can figure out if this is something new with 2007. Anyone have any idea?

 

[pbaldy]

If you look in VBA help at OpenReport, you'll see the argument you need to set.

 

[Johnny Drama]

Thanks! Found it

 

[pbaldy]

Happy to help!