Setting Criteria with a Lookup Field

[winteram]

I have a database and several queries. I have a form where the user types in the description of an item they are looking for. However, they will only be entering part of a description. Based on what they enter, I want the query I have to pop up with all items in the table that have what the user typed as part of its description.

I have already tried typing Like *[Forms]![FindByDescription]![txtSearch]!* into the criteria of my description field on the query, where "FindByDescription" is the form that the user types into and "txtSearch" is the search box they type into. It isn't working.

Any help would be much appreciated!!

[NoellaG]

Hi,

Like "*" & [Forms]![FindByDescription]![txtSearch] & "*"

greetings
NG