Resorting by Clicking on Column Heading

[khood]

Somewhere I have seen an example of how to display the results of a query, then allow the user to click on a column heading to resort by that field. Anyone have an example of this?

My approach is to add labels at the top of my control and requery with the new sort in the click event of that label. Is that the best way to handle this?

Thanks,
Ken Hood

 

[braindead2]

I would just place this on the click event of the field I want to sort by.
docmd.runcommand acCmdSortAscending

 

[khood]

Braindead2,

Thanks for your reply. I guess I was a little vague in my original post. The form has only an unbound listbox control based on a recordset, so I need to be able to detect which field they want to sort by.

Thanks,
Ken Hood