Mark,
For small sets this would work. But might hit the maximum command line length with large sets.
Cetin
>I would put a button by your listbox that says "DoQuery"
>In its click(), I would iterate through your list and make a delimited filter string:
>
>Public G_FilterStr
>G_FilterStr="|"
>with thisform.list1
>For i=1 to .listcount
> if .selected(i)
> G_FilterStr=G_FilterStr + .list(i) + "|"
> endif
>endfor
>endwith
>set filt to atc(trim(department),G_FilterStr) > 0
>Browse Nowait Normal
>
>that's all you need.
>
>if the values of T1...TLast can potentially be subvalues of each other (for example, "USELESS","VERYUSELESS", then the field would need have delimiters applied to guarantee correct results:
>set filt to atc("|"+trim(department)+"|",G_FilterStr) > 0
>>
>
>
>>Hi
>>
>>I have a form with a list box which has several values i.e. T1, T2, T3 ..........T7. This list box is not connected to any table. The values are added manually. I have a table from a database application which has thousands of records. One of those fields is called department and contained within the field are the values T1 or T2 or T7 etc.
>>
>>What I would like to do is to use the list box on my form (multiple select) and then click a button to find those records that match what I have selected in the list box. For example if I select T2 and T7 then it would list those records that have T2 and T7 in the department field. I suppose I need some looping statement to do this. Can anybody start me down the right path.
>>
>>Thankyou very much!
