Parameter query that looks at form textboxes for criteria

[ONT]

I have a query that is set to look at data inside of text boxes in a form for the query's criteria. The underlying data in the table is numberical.

In the form, I have textboxes to specify a beginning number and an ending number to be used for a range and a textbox for a list of values separated by commas. The query uses the between operator for the range and this works. Then, on the criteria "or" line, it uses the in operator for the list. It works if I input the values directly in the query, such as In(30,50,55,98), but not if I put those same values into the form textbox and direct the query to look to that textbox. If I put only one value in the textbox, it works, but not if I have multiple values.

[June7]

That's because the textbox input is only a string of characters - including the commas - not a set of values.

Review this for a method to create multi-value criteria from a listbox http://allenbrowne.com/ser-50.html