I am using this 'Where Condition' to pull data into a report : [Owner_lbl] =[Forms]![Search Form].[txtName] and it provides accurate results as long as the name entered in the search form is typed exactly as it is in the table/query
I would like to use a wild card or LIKE in order to allow for only a part of the name to be entered and still result in a successful search.
The owner_lbl field contains names that are one of three of the following:
singular owner ie: John Doe
two owner ie: John and Jane Doe
corporate ie: Acme Widget Co.
Any help on how I can achieve this would be great. I'm not new to coding but it's been so long that I may as well be.
Thanks for any assistance you can provide!