>I have the following code in the 'InterActiveChange' method of a listbox (.lstDim1):
>
>
>.lstDim2.RowSource = 'Select DISTINCT IIF(dim2-INT(dim2)>0,'+;
> 'ALLTRIM(STR(dim2,5,1)),ALLTRIM(STR(dim2))) AS dim2 FROM surface '+;
> 'INTO CURSOR curDim2 WHERE ALLTRIM(.lstDesc.Value)==ALLTRIM(desc) '+;
> 'AND .lstDim1.Value==fractionconv(dim1) ORDER BY dim2'
>
>
>
>This fills listbox 'lstDim2' with the correct data, but when I go to select a value the only values that will show up in the listbox are the ones that do not contain a decimal (i.e. ALLTRIM(str(dim2)) from above).
>
>Any suggestions would be greatly appreciated!
>
>Thanks in advance,
>Russell
It's been a while, but maybe you need to issue a requery after setting the rowsource.