Apply query criteria using listed contents of a Form text box

I wrote a select query in Access in the SQL viewer mode. My query contains the where clause:

WHERE ([Cases].[CloseCode]=[Forms]![devParam]![RsnCodes]);
*Note: I've also tried IN rather than = with the above where clause

*Note that [Cases].[CloseCode] is a column that stores text data with length=2 (e.g. "00" or "16" or "30")

I also have a form named "devParam" which contains a text box named "RsnCodes". I keep this form open when running my query.

I would like to do 2 things. Right now I can't do either.

1) Apply the where filter when someone inserts a single value in the text box. For example, user opens form and enters in "16" (without the quotes) in the text box. User then runs the query to get the results.

2) Apply the where filter when someone inserts a series of values in the text box. For example, user opens form and enters in "00, 16" (without the quotes) in the text box. User then runs the query to get the results.

Since I'm a beginner, I'd prefer not to use VBA at this time, rather stick to select queries, forms, and user prompts. thanks much.Start Free Trial