On Dec 6, 6:55 am, "Allen Browne" <AllenBro...[ at ]SeeSig.Invalid> wrote:
[Quoted Text] > <richal...[ at ]cs.com> wrote in message > > news:3381ab6c-523c-4d67-bd60-1724faab2c83[ at ]g38g2000yqn.googlegroups.com.... > > > 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.) > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html> Reply to group, rather than allenbrowne at mvps dot org.
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
|