What Event Fires after Filter By Selection?

[whdyck]

Does any MS Access event fire when clicking the "Filter by Selection" button? I mean *after* the filtering has completed?

I'd like to update a counter on my form after the filtering completes. I tried putting code in the ApplyFilter event handler, but it doesn't work. Online help says this:

The actions in the ApplyFilter macro or event procedure occur before the filter is applied or removed

Thanks.

Wayne

 

[theDBguy]

Hi Wayne,

Can’t test this right now but you might be able to use the Current event if it fires after the filter is applied.

Sent from phone...

 

[whdyck]

you might be able to use the Current event if it fires after the filter is applied.

You're right. Current does indeed fire after the filter applies, so that's what I'll use.

Thanks!

Wayne

 

[theDBguy]

Sounds good!