Microsoft Access Database Development With VBA

Filtering Records in Microsoft Access



To perform data filtering on a table, a query, a form, or a report, use its Filter property and assign it the WHERE condition. To apply the filter, access its FilterOn property and assign it a value of True. To remove the filter, assign the False value to its FilterOn property.

Here is an example:

Private Sub cmdShowCashiers_Click()
    Filter = "Filter = 'cashier'"
    FilterOn = True
End Sub

Home Copyright © 2011 FunctionX, Inc. Home