Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Report From a Form

Status
Not open for further replies.

gasx

Technical User
Feb 28, 2003
22
US
I put this code on click event on command bottom in my form to pull up print dialog box how can I use this mothed to print my report instead of my form without preview the report.

Private Sub print_Click()
docmd.RunCommand acCmdPrint
End Sub

 
not sure if this is what you are after but...
Code:
    DoCmd.OpenReport "rptYourReportName", acViewNormal
will send a report to the default printer.
This will not open the print command dialogue so will not allow you to select a printer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top