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