<%dim crumb crumb="DoCmd ApplyFilter" crumb1="Apply Filter DoCmd" %> DoCmd ApplyFilter in Microsoft Access
Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Forums  Blockchain Tech  Contact  Privacy  Links

DoCmd Examples - Access VBA<%response.write "
" & crumb1 %>

Docmd Macro VBA Example
Developer Home > Access Database Tutorials > DoCmd Examples<% response.write " > " & crumb %>
<% dim Gnum,Ynum Gnum="3847865006" Ynum="7164" dim Page_Type Page_Type="Prog" %>

DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs


Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013

DoCmd ApplyFilter to Tables, Forms or Reports

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:
Access Docmd ApplyFilter Method 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 property.

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 filter.

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

Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>