Preview:
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

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter