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.)
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
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
