P
Paul Fell
Access 2000
I have a form with a subform. The subform is displayed in data view of
one field only (many records). The user can filter in the data either
by right clicking to get to the normal access filter or by clicking on
the toolbar at the top. What I want to do is to write some vba which
will know and respond to this filter ie an event. Can someone tell me
in which event I should be writing my code? I've tried all the usual
ones (eg Before_Update, Change) but none of them seem to be triggered
by the filter.
Any help much appreciated
paul
I have a form with a subform. The subform is displayed in data view of
one field only (many records). The user can filter in the data either
by right clicking to get to the normal access filter or by clicking on
the toolbar at the top. What I want to do is to write some vba which
will know and respond to this filter ie an event. Can someone tell me
in which event I should be writing my code? I've tried all the usual
ones (eg Before_Update, Change) but none of them seem to be triggered
by the filter.
Any help much appreciated
paul