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
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
