View Report when using docmd.OpenReport

[randommetalguy]

Hello,

I am trying to go from a form to a report and it's not working out how I anticipated. Initially I was going from Form to Form and could use docmd.OpenForm "formname", acNormal however, when I try docmd.OpenReport "reportname", acNormal it doesn't display the report, it goes directly to printing.

Can I do a me.hide on the form and show reportname on the report to get this to work? Basically I don't want to automate printing, instead I want to be able to look at the report and verifty the report and have the option to go back and make changes on the form if need be. How can I implement this?

 

[pbaldy]

If you look at OpenReport in VBA help, you'll see that there's an argument you can specify to preview rather than print.