A
Amateur
I have a command button to print a report:
Private Sub Command85_Click()
On Error GoTo Err_Command85_Click
Dim stDocName As String
stDocName = "allclientsvaluesforcalculation"
DoCmd.OpenReport stDocName, acNormal
Exit_Command85_Click:
Exit Sub
Err_Command85_Click:
MsgBox Err.Description
Resume Exit_Command85_Click
End Sub
How can I change the code so, that it is asking for which salespersonid i
would like to print the report (I do not want to print the report always for
all salespersons)?
Thanks for your help.
Klaus
Private Sub Command85_Click()
On Error GoTo Err_Command85_Click
Dim stDocName As String
stDocName = "allclientsvaluesforcalculation"
DoCmd.OpenReport stDocName, acNormal
Exit_Command85_Click:
Exit Sub
Err_Command85_Click:
MsgBox Err.Description
Resume Exit_Command85_Click
End Sub
How can I change the code so, that it is asking for which salespersonid i
would like to print the report (I do not want to print the report always for
all salespersons)?
Thanks for your help.
Klaus