On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ListBoxSorting.mdb" which illustrates how to do this.

Signature
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
> how would i program a command button to sort a listbox ascending on the first
> click, descending on the second click? or should I just use a subform?