Set Filter Property on Subreport

[Jason760]

I use this code to filter forms

If Chassis = "CV" Then
Me.Filter = "[Process Family] Like 'CV*'"
Else
Me.Filter = "[Process Family] Like 'A3*'"
End If
Me.FilterOn = True

But I can't get it to work on a SubReport.
Should it be the Filter property be set in the Main Report, and How should the code be different to filter the records.

 

[peterbilt]

You must apply the filter to the subreport itself. Unfortunately, with reports, it must be open in design view to set the filter property. For example:

DoCmd.OpenReport MySubReport, acDesign
If Chassis = "CV" Then
Me.Filter = "[Process Family] Like 'CV*'"
Else
Me.Filter = "[Process Family] Like 'A3*'"
End If
Me.FilterOn = True
DoCmd.Close acSaveYes

Double-check the exact syntax, but you get the idea.

Aaron

 

[Jason760]

Thanks for your help!

I couldn't Figure out why access wouldn't let me set the filter. It's good to know how to do it now. thanks again.