Sorting Column Head in a listbox

[nim180]

Hi Everyone,

I have a form with 2 textboxes, a search button and a listbox. The user inputs information into the textbox and clicks the Search button which in turn populates the listbox with the results. All of this works fine but i was hoping someone could help me with the following. I have the setting 'column head' set as "YES" in the listbox. What i would like to happen is, if the user clicks on one of the column heads (There are 8 columns) it will sort the results in ascending order and descending if click twice. Is this possible to do?

Thank you for your help.

Nim

 

[nim180]

Hi everyone,

Got it sorted with abit of coding.

nim

 

[Remou]

It is always good to have the answer posted.