472,779 Members | 1,751 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,779 software developers and data experts.

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 2603

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Tim Marshall | last post by:
The following is happening in two instances in A2003. The one I s\describe is the easiest one. Theme controls and autocorrupt have been turned off long ago. An unbound main form with a list...
by: Filips Benoit | last post by:
Dear All, What event can track the menu-item or shortcut-menu-item 'Remove Filter/Sort' - click. Or the opposite op Apply-Filter-event. Thankł, Filip
by: Chris Moore | last post by:
I have a .NET form where I am updating a progress bar & counter. As long as the form never loses focus, everything on the form refreshs fine. But If I open another window (like Windows Explorer)...
by: Denis | last post by:
How do I set up a button to remove a form filter. I can get a button the edit the form filter by nowt remove it. I don't want the have the use the remove filter on the records menu Thank you
by: NewtoAccess | last post by:
App; ACCESS 2003 Question on FORMS What command line can i add to a button in a FORM that will remove current filter? I hid the scroll bar towards the bottom of the form since I dont want...
by: mattscho | last post by:
Hi All, Trying to create a set of 3 buttons in a form that have the same effect as the "Filter by Form", "Apply Filter" and "Remove Filter" Buttons on the access toolbar. Help would be muchly...
by: Matthew Wells | last post by:
Hi there. I am a programmer for a living, but this problem has my whole team stumped. I have a subform based on a query. I'm not using the "LinkMaster/ChildFields" properties ( I have my...
by: =?Utf-8?B?R3JlZw==?= | last post by:
I have the following code the dynamically adds a specific number of controls. for x as integer = 1 to 10 Dim btn as Windows.Forms.Button = New Windows.Forms.Button btn.Name = "btn" & x btn.Text...
by: Jim Mandala | last post by:
Using Access 2003 front end; SQL Server 2005 Back end: I have a complex form that has lots of data fields including about thirty or so checkboxes storing Yes/No data that I would like my users...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.