Clear up a misconception?

[GraeagleBill]

It's always been my understanding with reports that IF one needs to set RecordSource and filters in code when a report OPENs that the "Me.RecordSource =" should be coded in the OnOpen event and the filter property for the report be set in the OnActivate event. I seem to be having some problems with a report where the filter doesn't apply itself when I run the report.



Can someone straighten me out on the proper placement of the required code to assign the RecordSource =, Filter = and FilterOn?

Me.Filter = strRptFilter
Me.FilterOn = True

[Micron]

To apply a filter automatically when a form is opened, specify in the OnOpen event property setting of the form either a macro that uses the ApplyFilter action or an event procedure that uses the ApplyFilter method of the DoCmd object.

Maybe on some of the ones you have trouble with, you have Filter On set to No? Not sure what the implications of that would be. I presume code would overr-ride, provided that it's placed properly. I'd also say that Activate is too late - the report is already poplualted and formatted.

[GraeagleBill]

Thanks Micron. I think my problem stems from my misunderstanding of how and when OnActivate code takes effect. I'll put the pertinent code in the OnOpen in a bit and report back.
Bill

[GraeagleBill]

Thanks Micron. I think my problem stems from my misunderstanding of how and when OnActivate code takes effect. I'll put the pertinent code in the OnOpen in a bit and report back.
Bill

Two problems revealed as I continued in Debug mode. The first was that I had the Me.Filter = AND Me.FilterOn = True in the OnActivate event rather than OnOpen where it belonged. The second issue was a simple oversight on my part when setting the filter expression itself. Both corrected and the report now runs as desired.
Thanks again,
Bill

[Micron]

Glad to help.