Set a printer for three separate print jobs insuccession??

  • Thread starter Thread starter SAG
  • Start date Start date
S

SAG

I want to use:
Private Sub Report_Activate()
On Error Resume Next
DoCmd.RunCommand acCmdPrint
DoCmd.Close acReport, Me.Name
End Sub
for the 1st of three reports. If possible I'd like to
save the user's selection for report 1 and use it for
reports 2 and 3. Instead of prompting the user each time.
Please help with VBA samples.
I use MS Access 2002.

Steve
 
Use DoCmd.OpenReport to run reports. Do not put in an instruction to Close
the Report... it will close when it is complete.

But, I see nothing here to indicate a user selection.

Perhaps you are talking about something other than Reports?

Larry Linson
Microsoft Access MVP
 
Back
Top