If your table field is a 2 character field containing one code, then the
answer is no. The query builder is not smart enough to know which of the
codes you want to use. Based on your post, I think you need to reconsider
your design. Can you tell me why you are using comma separatorated codes in
a text box when you need to look up only one?

"Gwhit" wrote:

If I have a text box named [States] on my [Workstation] form, and this text
box contains simple two-letter state codes with comma separators, for example
"AZ", "CO", "WA", etc, should I be able to reference this text box in the
criteria grid under a Project_State field with code along the lines of,
In(Forms![Workstation]![States])? I seem to be able to type only one state
reference into the text box with no surrounding quotes and receive a correct
return of data.

Thank you.