criteria taken from a form control (text box)... Help

[everblue]

Dear All,
Please read the situation first and help me if possible....

I am using a form, it uses two combo boxes and one text box. In the underlying table, i have a field called (prob_id). I want to extract some values for (prob_id) from those text boxes and I place them in another control on the form called (id), seperated with commas. suppose the (id) control holds the following values... (1,2,3,4).
I have a query that displays all the fields from a table. in the criteria of (prob_id), i have written this....

in ([forms]![search]![id])

since the id text box in the form holds (1,2,3,4), when it is passed to query, it will be like

in (1,2,3,4)........ and the query should display 1-4 records. while it doesn't.

if id textbox held only one value like (3), then it displays that record. if more than one value, it doesn't....

how can u help me achieve that........

thanx

 

[Fuga]

If I were you I´d try to seperate the different values in their own variables, so that you can define the where clause with 1 or 2 or 3 or 4 etc rather than 1,2,3,4.

Fuga.