If the table is in the form's DE you can set the order there. Just select the table and in the property sheet click the data tab and the set the order property.

I'm not sure what happens when you change the index on the fly but you can call the listboxes requery method and I would think it would repopulate the listbox with the new index set.

>Greetings and Salutations!
>
>I'm trying to use a list box to display data and double as a navigation tool through a table. Ergo, I'm setting RowSourceType to "6 - Fields." How can I have the list box reflect an active index or filter? It seems that it always reads all the data in record order.
>
>And if we get this far, how can I change the index or filter on the fly and have the control requery or refresh to reflect this change?
>
>Thanks in advance.
>
>Cheers, Harry