I have a form that has a list box, text box and command button. The list box is a multiple select list box.
I want the user to select the criterias and click the button. Once the button is click I go through the list box and collect the ID number that was selected and put them into a string. I set the text box to this string. The sting is something like this: In (1, 6, 8)
Then in my query I have the criteria looking at the textbox that contains this string.
But it does not work. If I manually type in the string into the criteria of the query it works but not if its in a textbox.
Can someone shed some light? Or would I have to do a QueryDef. I rather not do a query def since the SQL is complicated.