Gudday,
I have an Access 2000 database which I am using as a phone directory
of residents in the hostel where I work. The front end for this
directory is a form with a text box (the search name etc) and two
combo boxes that let you choose options relating to the search name.
These three controls are referenced by a query, the results of which
are the control source for a subform on the main form. so far, so
good.
Now, what I want is every time you change the search criteria in the
text box, the query runs and the subform shows the new result eg. if I
type "smith", I will first get all the records containing "s", then
"sm", then "smi" etc etc as I type out the full word. I have achieved
this using the Me.refresh command in the on_change event. This works
well. So far, so good.
The problem comes when I manually try to apply a filter over the top -
the standard filter menu works well, doing everything I'd want it to.
The problem arises when I click "Remove filter" - suddenly, the
Me.refresh command stops working - if I turn the filter back on, it
starts again. So, the question is, what exactly is it that is turning
the refreshing command off? How can I circumvent this?
Mark
