I am trying to build a query form that searches for a close match, am using the following code, it pops up the parameter prompt but doesn't return any results....
SELECT *
FROM CompanyContacts
WHERE CompanyName LIKE Forms![CompanyContacts]![CompanySearch];
scrap that last - works like a charm. one question though, the * is a wild card for the remainder of the field. how would I introduce a wildcard for the begining of the feild as well i.e. *foo*? As you have probably gathered - I ain't no VB programing wizard....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.