VBA report printing issue

[skp]

I have a report that the users will be printing from database view not design view, I have a print button set up that is working perfectly fine except it will only print the 1st page of the report and its multiple pages. Any help would be great.

Here is the code I have on the button;
Private Sub cmdPrint_Click()
Forms("frmReports").Printer.Orientation = acPRORLandscape
DoCmd.PrintOut , 1, 1, acLow, 1, False
End Sub

 

[Trevor G]

try this line

DoCmd.OpenReport "rptEmail", acNormal

 

[Trevor G]

Please don't start new threads asking the same question this breaks the forum rules.