The Apply Filter method is used the
restrict the records show in forms, reports and queries.
The following example demonstrates the
Docmd.ApplyFilter command when used to restrict the selection of records by
the State field in our combo box.
Here are the syntax and options for the apply filter command:
Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
FilterName Optional Variant. A string expression that's the valid name of a
filter or query in the current database. When using this method to apply a
server filter, the FilterName argument must be blank.
WhereCondition Optional Variant. A string expression that's a valid SQL WHERE
clause without the word WHERE.
The filter and WHERE condition you apply become the setting of the form's Filter
You must include at least one of the two DoCmd.ApplyFilter method arguments. If you
enter a value for both arguments, the WhereCondition argument is applied to the
The maximum length of the WhereCondition argument is 32,768 characters.
If you specify the WhereCondition argument and leave the FilterName argument
blank, you must include the FilterName argument's comma.
Docmd ApplyFilter Example:
The following example uses the Docmd.ApplyFilter method to display only records that
contain the state MD in the State field:
DoCmd.ApplyFilter , "State = 'MD'"
An alternate method is to set the filter property setting of
a form directly. In this
example we also use a combo box to select the state:
Form_F_Orders.Form.Filter = "State='" & Me.State_Combo &
Form_F_Orders.Form.Filteron = True
See an example of applying a filter directly to a form:
Recordset Filter in MS Access