ApplyFilter question

[arage]

In the open event of my REPORT I am using the applyFilter method to only display certain pages based on whoever the user is. But I’m getting run time err message 2488 – that I can’t apply a filter to the window. The code has worked the way it is before & never encountered this message, the reasons why I can’t according to the err msg confuse me though:
Reason1- I didn’t apply the filter to a report—what do you mean, the method is in the open event of the very report I want.
Reason2-you may have specified the filter to a report but didn’t use the applyFilter action in a macro specified by the OnOpen property—This can’t be as I have no macros to begin with.

Then I’m told to use the selectObject method/action to select the report, but why if the applyFilter is IN the report’s event to begin with?

 

[MHM]

At the Form_Open event data is not yet load. Maybe you use the Form_Load event. Or type
me.Filter = "ID<100" ' e.g.: <100
me.FilterOn = True

 

[arage]

MHM,
If that’s the case why do I have another report that uses the applyFilter method in an almost identical way previously described that works? I mean to say in that it’s openEvent does use the applyFilter method.

 

[arage]

As per MHM’s formLoad event suggestion, is this possible? I mean to associate a formLoad event with a report? Isn’t formLoad just for forms?