Automatic Filter In Ms Access

PHOTO EMBED

Sun Sep 01 2024 23:36:39 GMT+0000 (Coordinated Universal Time)

Saved by @rmdnhsn

Private Sub txtCustomerName_Change()
    Dim strFilter As String

    strFilter = Me.txtCustomerName.Text

    Me.frmCustomers_sheet.Form.Filter = "CustomerName LIKE '*" & strFilter & "*'"
    Me.frmCustomers_sheet.Form.FilterOn = True
End Sub

content_copyCOPY