click on listbox column and change order of records

[antonyx]

hi

i have a listbox..

i want to change the order of the records whenever my user clicks on one of the fields (columns)

MY CURRENT SITUATION

my records are selected thru a query that puts them in order of date created (descending)

one of the fields that displays in the listbox is jobdate.

if my user clicks any record in the job date column, can the listbox be re-queried?

 

[Luddite Lad]

This thread has a solution to your problem