Report auto printing

[Ali509]

Hi.
I hope I can explain this without it being too confusing. I made a form as an unbound combo box to pull in data and place in a report. When I had the form linked to a query it worked beautifully but I needed it to open the report.

So in the property of the unbound combo box, under the event tab I switched out the query for the report by using this code...

DoCmd.OpenReport "Current Year - Records by Type Incomplete", acViewNormal, acEdit
DoCmd.Close acForm, "TypeFrm"

It pulls the records great, but prints it automatically which I don't want it to do. I've done and gone everywhere I can think to stop it from printing.
The user doesn't even see the report, it just auto prints.


The only thing left is the code. I'm thinking I have it wrong.

Any suggestions would be great.

Ali

 

[pbaldy]

Did you look at the arguments of OpenReport? acViewNormal will print; you want acViewPreview.

 

[Ali509]

OMG! You are GENUIOUS!! Thank you!!

 

[pbaldy]

Happy to help!