I have a form called frmEmail. In the frmEmail I have a text box called txtEmail. I have a query called qryEmail. What I'm trying to do is, allow the user to type anything he/she wants into the text box and i'll filter the query on what ever they type. I know you're suppose to use the Like expression. This is what I've tried thus far in the criteria of the query.
Like "*Forms![frmEmail]![txtEmail]*"
When I type something in there it wont pull up any data. This should work but I'm baffled at why it won't work.
Thanks in advance.
Like "*Forms![frmEmail]![txtEmail]*"
When I type something in there it wont pull up any data. This should work but I'm baffled at why it won't work.
Thanks in advance.
