MS Access SQL - Like statement with object value

[brian_msbc]

I want to use this code in the rowsource for a listbox:

 SELECT DISTINCT mps.[Partner Name]
FROM MasterProfileSummary AS mps
WHERE (((mps.[Partner Name]) Like [Me]![TextSearch])) OR ((([ME]![TextSearch]) Is Null))
ORDER BY mps.[Partner Name];

But I'm getting an enter Parameter value error. I'm only assuming i'm using "Like" incorrectly. Should there be a wildcard notation? if so, how would that look?

update- I changed [ME]! to the actual form object path which solved the enter parameter value problem, but im getting no records, I think its because of the wildcard thing.

 

[pbaldy]

The error is because you can't use "Me" in a query, only in VBA. You need the full reference:

http://www.mvps.org/access/forms/frm0031.htm

You would also need a wildcard if you want one.

 

[brian_msbc]

Thank you for the link for when and how to use [ME]!.

How do you correctly use wildcards in a like statement when referencing objects?

 

[pbaldy]

For both sides:

Like "*" & [forms]![FormName].[ControlName] & "*"