G
Guest
I have the following code that I use to print a report:
Private Sub cmdPrintEmpNum_Click()
On Error GoTo Err_cmdPrintEmpNum_Click
Dim stDocName As String
stDocName = "rptEmpNum"
DoCmd.OpenReport "rptEmpNum", acNormal, , "[EmployeeNumber]=" &
Me.cboEmployeeNumber
Exit_cmdPrintEmpNum_Click:
Me.cboEmployeeNumber = Null
Exit Sub
Err_cmdPrintEmpNum_Click:
MsgBox Err.Description
Resume Exit_cmdPrintEmpNum_Click
End Sub
I want to add the print dialog box so the end user can pick what printer
they want to print to. I have tried to insert the following code in numerous
places with out success:
DoCmd.RunCommand acCmdPrint
Can someone help me on what I need to change so the end user can have a
print dialog box!
Thanks
R~
Private Sub cmdPrintEmpNum_Click()
On Error GoTo Err_cmdPrintEmpNum_Click
Dim stDocName As String
stDocName = "rptEmpNum"
DoCmd.OpenReport "rptEmpNum", acNormal, , "[EmployeeNumber]=" &
Me.cboEmployeeNumber
Exit_cmdPrintEmpNum_Click:
Me.cboEmployeeNumber = Null
Exit Sub
Err_cmdPrintEmpNum_Click:
MsgBox Err.Description
Resume Exit_cmdPrintEmpNum_Click
End Sub
I want to add the print dialog box so the end user can pick what printer
they want to print to. I have tried to insert the following code in numerous
places with out success:
DoCmd.RunCommand acCmdPrint
Can someone help me on what I need to change so the end user can have a
print dialog box!
Thanks
R~