using sql to set a a reports recordsource (1 Viewer)

[gbanks]

Using this code as part of a module to open a report in print preview and set it's recordsource to the sql I have written earlier in the code. The problem is when I run this it only prints the report it won't show it to me in print preview like I want. Anybody know what's wrong? Thanks...


DoCmd.OpenReport "SitesIssues_qry", acViewNormal, "", "", acNormal
Me.RecordSource = strsql & " " & strWhere & "" & strOrder

 

[john471]

Use acViewPreview in lieue of acViewNormal.

acViewNormal ==> print.

hth

regards

John.

 

[gbanks]

Thanks

Thanks John That was it..