What Event Fires after Filter By Selection? (1 Viewer)

whdyck · Nov 19, 2018

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 · Nov 19, 2018

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 · Nov 23, 2018

theDBguy said:
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 · Nov 23, 2018

Sounds good!

What Event Fires after Filter By Selection? (1 Viewer)

whdyck

Registered User.

theDBguy

I’m here to help

whdyck

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread