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