Report Doesn't Print

G

Guest

I have a report that when I open it in print preview and right click on it
and hit print, it prints fine.

But I have a command button on a form "Print Case Report" that won't print
the report. It appears to go to the printer as I can see momnentarily the
little "printing pages 1-6", but then noting prints out. As I said, it will
print using the right click print in print preview. I don't understand this.

Any help is greatly appreciated. Here's the code behind the button. Thanks,
Rob


Private Sub cmdPrintCaseReport_Click()
On Error GoTo Err_cmdPrintCaseReport_Click

Dim stDocName As String

stDocName = "rptCaseReport"
DoCmd.OpenReport stDocName, acNormal
Debug.Print

Exit_cmdPrintCaseReport_Click:
Exit Sub

Err_cmdPrintCaseReport_Click:
MsgBox Err.Description
Resume Exit_cmdPrintCaseReport_Click

End Sub
 
G

Guest

Check the Report Default printer set up, mybe it set to another printer, and
this is why you cant see the print out.
 

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

Top