Report prints Automatically - how to stop it??

[EricaP]

Hi everyone,

So I have a multi-field search form with a tickbox that is tied to 2 queries that is tied to 2 reports. The form works great and I get all the results I want, but my report doesn't display on my monitor, it simply prints up! How can I get it to stop doing this and show only on my screen?

My code on the "run search" button is:

If Me.[OptionalCheckBox]=True Then
DoCmd.OpenReport "rptReport1" acViewNormal, acWindowNormal
Else
DoCmd.OpenReport "rptReport2" acViewNormal, acWindowNormal

Thanks!

 

[CJ_London]

Change acViwNormal to acViewPreview