>>I have a multi select listbox that I loop thru and create a string of ID's of the selected items. For example, lets say that there are three items selected in the listbox. The string would look like this:
>>
>>"AAAAAb,AAAAAH,AAAAAc"
>>
>>I store this value to a form property i.e. THISFORM.VSTRING
>>
>>In the View Designer, my view looks like this:
>>
>>SELECT Notes.no_id, Notes.co_id, Notes.recordkey, Notes.nn, Notes.sn,;
>> Notes.name, Notes.contdate, Notes.note, Notes.phone, Notes.callback,;
>> Status.st_status, Notes.st_id;
>> FROM planetrk!notes INNER JOIN planetrk!status ;
>> ON Notes.st_id = Status.st_id;
>> WHERE Notes.st_id IN (?THISFORM.VSTRING);
>> ORDER BY Notes.co_id, Notes.name, Notes.contdate DESC
>>
>>I'm doing something wrong, 'cause I'm not getting the 3 ID's that I
>>want.
>>
>>What am I doin' wrong?
>>
>>Best
>>Dave
>
>Try:
>
>WHERE Notes.st_id $ Thisform.Vstring instead of IN.



Hi Jess,

The $ isn't one of my options in the View designer.