Tuesday, May 16, 2017

Sort Listboxes

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

No comments: