Having trouble passing an in-list string to a query.

In my Form I have a text box that is updated as the user selects values. They can then "Process" those values. When they click "Process" it loads a sub-form so they can assign some attributes to those values. That all works, and my SQL update works as well.

One of the complaints is that they want a list box to show data from the table for reference.

So, I created a query where I passed the string from the text box to an "IN" criteria in the query. This query populates a list box.

Textbox values = 'value1','value2','value3'

Query is setup like: IN ([Forms]![Form]![TextBox])

Through testing, it works if I only send one variable and remove the "'"

It appears it's doing SELECT * FROM dbo.table WHERE VALUE IN ("value1")

So, I updated the textbox to use double quotes instead of a single quote.

SELECT * FROM dbo.table WHERE VALUE IN ("value1","value2")

It fails. What am I doing wrong?