By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Remove filter stops form from refreshing

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.