VBA Syntax for wildcard filter
Posted on 2011-02-15
I use the following code under a button to filter a form based on the Business Name field:
Me.Filter = "[Business Name]='" & Me.Find & "'"
Me.FilterOn = True
This works well for a one word business name such as "Acme"
I would like to change the filter to allow the use of the * wild card so I can find "Acme Inc." "Acme Corp" or "The Acme Company":
How do I change this syntax to filter by business name with the star wildcard before and after
Thank you in advance for your help.