Hi I am trying to print an envelope from a customer form. I have a button that brings up the correct envelope report with the customers data in it but I want the envelope report to print without preview.

I am using
Private Sub Print_Envelope_Btn_Click()
strReportName = "Envelope"
strCriteria = "[CustomerID] = " & Me![CustomerID]
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub

Can someone tell me what else I need to add to this to make it print without preview.

Thanks

Howzit

You have the property set to preview (AcPrintPreview) - I think it needs to be acPrintNormal...

sorry that should be acViewNormal

Perfect, thank you.