OpenReport command VBA 1

[lemmiwinks30]

When my user clicks a button which launches a report, it seems that your only options with the OpenReport command are acViewNormal, which automatically prints with no preview or acViewPreview which lets you preview but you cannot then print. Is there a way that I can let my user first preview the report that was generated and then print from there? I know that within Access if you are in the Reports tab you can click preview and then print, but my users would never see that end of the program.
Thanks!

 

[PHV]

acViewPreview which lets you preview but you cannot then print
Really ? Have you masked the menu bar ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lemmiwinks30]

Thanks so much for your help! It works great.

Kathy