Passing a form variable to IN() function in query

[Jackie]

I collect data in a text box (txtAppSelected) on a form. The data is stored in the following format: "abc","def","ghi"

The following statement is in the criteria field:

In ([forms]![key word search]![txtAppSelected])

The problem is the query returns zero records, although record matches exist.

What is the correct syntax for passing a variable? I have experimented with a variety of single and double quote combinations, but with no success.

Thank you in advance for your response.

 

[Databaseguy]

Try:

Like "*" & [forms]![key word search]![txtAppSelected]) & "*"
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy