Using wildcards (Like operator) in a VBA parameter prompt.
Posted on 2013-01-24
I am trying to create a button that the user clicks, and is prompted for Equipment name (InvPCName).
I want them to be able to enter the actual name or wildcards (*part of name*) or part of name with no wild cards.
Once they click OK, I want a the same form to open with only the records that match the query.
Right now, a simple [Enter Equipment Name] in the WHERE condition works, but doesn't accept wildcards, only the exact name.
I would love for it to behave just like the "contains" function on the right-click menu in Access 2010, if possible.