I have used LIKE with/without a wildcard and it worked for me.
For instance, a combo box on a form with definitive selections for query criteria, and a "*" added to the rowsource in case you want to pass all records...
In the query, I use LIKE Forms!MyForm!cboCriteria. If you select the...