That works great!

Thanks,

-Michelle


>>I have a listbox as a lookup. By choosing from an option group, you can order it by each of the four columns. The problem is that the incremental search always works on the first column.
>>
>>Is there a way to either change which column to use for the IS (preferred) or re-arrange the columns? The rowsource is a view.
>>
>>Thanks,
>>
>>-Michelle
>
>You can make a trick by adding 'invisible' first column with 0-width (list.columnwidth=0). Then changing list.rowsource on fly like:
>from List.Rowsource="MyTable.Field1,Field1,Field2,Field3..."
>to List.Rowsource="MyTable.Field2,Field1,Field2,Field3..." etc.
>you will simulate (from user's standpoint) interactivesearching from 1st to 2nd column etc. Remember to issue List.Requery anytime you change List.Rowsource