reports not going to default printer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a print command button on a form:

Private Sub cmdPrintCG_Click()
On Error GoTo Err_cmdPrintCG_Click
DoCmd.OpenReport "rptPKCorrugated", acViewNormal, ,
"[tblProfiles.txtProfileID] = Forms![frmPKCorrugated].form![txtProfileID]"

Exit_cmdPrintCG_Click:
Exit Sub

Err_cmdPrintCG_Click:
MsgBox Err.Description
Resume Exit_cmdPrintCG_Click

End Sub

When I use this button the report isn't sent to my default printer. Any
ideas why?

THANKS!
 
JohnLute said:
I'm using a print command button on a form: [snip]

When I use this button the report isn't sent to my default printer.
Any ideas why?
Click to expand...

Go to Page Setup for that report and change it to "Default Printer" (second
tab). At some point you must have accidentally saved it so it was set to
"Use Specific Printer".
 
Thanks! That was an easy fix and one I should've seen!

--
www.Marzetti.com


Rick Brandt said:
JohnLute said:
I'm using a print command button on a form: [snip]

When I use this button the report isn't sent to my default printer.
Any ideas why?
Click to expand...

Go to Page Setup for that report and change it to "Default Printer" (second
tab). At some point you must have accidentally saved it so it was set to
"Use Specific Printer".
Click to expand...
 
Back
Top