form filter

[richaluft]

Anyone know in what form event a form filter gets applied?
Thanks
RL

 

[Allen Browne]

Anyone know in what form event a form filter gets applied?

Forms have an OnFilter event that Access is supposed to trigger when a
filter is applied.

But that could be triggered by other events (e.g. the Click event procedure
of a command button where you have written code that applies a filter), or
no no event (e.g. user clicks Filter By Selection on the toolbar/ribbon.)

 

[richaluft]

 

Forms have an OnFilter event that Access is supposed to trigger when a
filter is applied.

But that could be triggered by other events (e.g. the Click event procedure
of a command button where you have written code that applies a filter), or
no no event (e.g. user clicks Filter By Selection on the toolbar/ribbon.)

Allen;
Not quite my question: let me try to clarify question.
There is a Filter property for a form, located on the property sheet
'data' tab for the (any) form. My question has to due with which form
event (eg: open --> load --> resize --> activate --> current) such a
filter would be applied. My reason for knowing this has to do with
the second part of my question (which you also tried to answer)
because I would like to be able to call that event from a 'new record'
cmdbtn on the same form, so that the filter will be reapplied to the
form for the new record to be entered.
I hope that this helps clarify my question(s).
RL

 

[richaluft]

 

Forms have an OnFilter event that Access is supposed to trigger when a
filter is applied.

But that could be triggered by other events (e.g. the Click event procedure
of a command button where you have written code that applies a filter), or
no no event (e.g. user clicks Filter By Selection on the toolbar/ribbon.)

Allen;
Thanks for your response.
I now realized that I am not asking the correct question for the
problem I'm having. Will submit new (and more appropriate question.
RL