Printing Current Record

  • Thread starter Thread starter RML
  • Start date Start date
R

RML

I'm using a button on a form to print the current
record. When I push it, the current record is printed.
The only problem is it goes directly to the printer. I
would like the the printer screen to display so I can
select a printer.

Thanks.
 
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String

stDocName = "ProposalActivity"
DoCmd.OpenReport stDocName, acNormal

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub
You probably used the button wizard to make code like this.
change the docmd line last word from acnormal to acpreview
"docmd.openreport stdocname, acpreview"

-----Original Message-----
From: RML [mailto:[email protected]]
Posted At: Friday, March 19, 2004 12:09 PM
Posted To: forms
Conversation: Printing Current Record
Subject: Printing Current Record


I'm using a button on a form to print the current
record. When I push it, the current record is printed.
The only problem is it goes directly to the printer. I
would like the the printer screen to display so I can
select a printer.

Thanks.
 
I'm using a button on a form to print the current
record. When I push it, the current record is printed.
The only problem is it goes directly to the printer. I
would like the the printer screen to display so I can
select a printer.

Thanks.
Click to expand...

A command button on the form?
Change the code used to open the report to open it in preview:
DoCmd.OpenReport "ReportName", acViewPreview

You didn't post your actual code, so the best I can do is give you a
generic version.
 
Back
Top