We must have order
"A nice way to enhance your application is to give your users the ability to sort the contents of listboxes.
If you have a listbox with many records, this feature could be much appreciated. It's easy to manipulate the listbox RowSource property to accomplish this.
A command button could be used to add an "Order By" clause to the SQL statement, and once the RowSource property is updated, the list is automatically sorted."
An example showing exactly how to do this is available for download as a Zip file here:
Sortable Link Boxes
from Peter's Software
See all Topics