470,609 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,609 developers. It's quick & easy.

Remove filter stops form from refreshing


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

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?

Nov 12 '05 #1
0 2484

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Filips Benoit | last post: by
1 post views Thread by Denis | last post: by
2 posts views Thread by Matthew Wells | last post: by
2 posts views Thread by =?Utf-8?B?R3JlZw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.