LIKE not working with wildcard in MS Query

Hi All,

I'm having trouble getting a wildcard to work in my query. This table connects to an Access database with ODBC and the queries are entered through MS Query. Here's the query:

Please Login or Register  to view this content.

In the LIKE parameter, I'm trying to pass the value along in a variable defined through a UserForm. If I select, say, 2013, then it changes the LIKE to LIKE '2013' and it works fine. However, when I select *, it evidently passes the parameter on but then it does not return any records. If I go into the MS Query application then the same thing happens. However, if I do it in Access, it works fine and returns the correct records.

What's going on here?

edit: Also, here's the code in VBA

Please Login or Register  to view this content.

% is the wildcard not *.

Yes * is the wildcard for Access, but % is the wildcard for MS Query.

If it's not working for you why not remove the WHERE clause if * has been entered/selected in the userform?

PS What's the field type of the field you are setting the criteria for?