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