General information
Category:
Forms & Form designer
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only