I would like to make a query that allows the user to be able to search my Description field. I dont want the user to have to open the query in design mode and enter *Jim* under criteria.
I found this code:
Like "*" & [Forms]![Search]![ Emp Name] &"*"
I entered this in the criteria. Then I created a Form called "Search" with a field named "Emp Name". I then created a button that opens up the query.
For some reason it is not connecting the Emp Name to the Query.