We all know how to use a query with a criteria of Like “*ABC*” to find everything with ABC in it…..
What I want to do is have a user enter a String (such as ABC) and have the Query go insert that strig.
Example:
Form Name: Finder
Form Field: StringFinder
I’ve tried building a string on the form with the Like and *’s – and setting the query criteria to [Forms]![Finder]![StringFinder]
It does not work…..
How can I do this??? Please try out your method first as I have tried 10 different variations and none work…
Thanks!!!!
Alan
Staten Island, New York
