how to enter print preview report's filter automatically from the current form

[isaace]

I have an agreement template in a MS access report. The report's fields are populated by the form's records. my goal is to automate the report to filter to the agreement # to what ever the current agreement # on the form is. i do not want to have to enter the agreement # every time i click on the cmd function to preview the report. below is the code i have, can someone please edit my code to what it should be?

Private Sub Command99_Click()
On Error GoTo Err_Command99_Click
 
 
'Defines Variables:
    Dim stReportName As String
    Dim stFilter As String
 
    'stFilter = [Agreement#].Value
 
    stReportName = "rptLicenseAgreement"
    DoCmd.OpenReport stReportName, acPreview, , stFilter, acDialog
 
 
Exit_Command99_Click:
    Exit Sub
 
Err_Command99_Click:
    MsgBox Err.Description
    Resume Exit_Command99_Click
 
End Sub
 
 

thanks!

[NeoPa]

No. They can't. That is not an acceptable request here.

Look at Example Filtering on a Form and learn to do it for yourself.