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?

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?

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top