how do i view a report, not automatically print?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi, I have a command button on a form. I want it to bring up a report to
preview it before I print it. Right now when I push the button it just
automatically prints the report.
I am using Access 2002

docmd.openreoprt ("delivered")

I tried putting in view as acpreview = acpreview but i keep getting an
error. Can someone please tell me what I am doing wrong and how I might
code this to get the preview?

Thanks,

Jeff
 
DoCmd.OpenReport "NameOfReportHere", acViewPreview

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Thanks for the help, I had also just figured it myself also. I did not need
the parentheses I was able to get it to work with this.

DoCmd.OpenReport "delivered", acViewPreview, , , acWindowNormal
 
Back
Top