VBA Programming in Microsoft Access: Filtering Records in Microsoft Access

	Filtering Records in Microsoft Access

Introduction

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