I have a continuous form that I want to sort by the column (field) when the lable is clicked. If the field is currently in DESCENDING then I want to reverse the sort when clicked. If no sort is currently on then sort Ascending.
What is the best way to do this?
me.orderBy or DoCmd.runcommand ascmdsortascending?