Lesson 6 says you're creating a "Print" button, but you're really only creating a "Print Preview" button.  What if you want to have the VBA code get the user to the window that selects which printer you want to print to?

---

Reply from Alex Hedley:

Untested and make sure there is only 1 page in your report.

* replace "REPORTNAME" with the name of your Report.

DoCmd.OpenReport "REPORTNAME",  acViewPreview , , , , acHiden
Docmd.SelectObject acReport, "REPORTNAME" 
DoCmd.RunCommand acCmdPrint

Alternative
DoCmd.PrintOut

DoCmd.OpenReport "REPORTNAME", acViewPreview, , , acHidden
DoCmd.SelectObject acReport, "rptCertificate_1"
DoCmd.PrintOut acSelection
DoCmd.Close acReport, "REPORTNAME"