>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
Edward Pikman
Independent Consultant