Report preview can't stay?

G

G Lam

Hi, I want to preview a report before it gets printed. I wrote the following
codes, but I only saw the screen just flashed once then the form closed. The
report preview does not stay on the screen. The code just keep on going. How
can I keep the preview on screen?
Thank you.
Gary
Click button sub:

DoCmd.OpenReport "rptQVSPList", acViewPreview, "qryQVSPLIst",
WhereCondition:="SlsOrdNbr = " & SORRdNbr
DoCmd.Close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print preview zoom 100 doesn't work 2
access report 0
Closing print preview after printing 4
Print preview with page range 0
Print but No Preview 1
report with query parameter and no data 3
Print a report without displaying print preview 1
Problem when export a report to a pdf file 1

Top