I am struggling with creating commdand buttons for sorting on a field. Here
are the codes in the two buttons:

ascending sort button...
Me.OrderBy = "[Vendor_JE]"
Me.OrderByOn = True

descending sort button...
Me.OrderBy = "[Vendor_JE]Desc"
Me.OrderByOn = True

The ascending button seems to work. My question is why isn't the descending
button working and how to do clear out the OrderBy in the forms property.
Thanks!

--
Message posted via http://www.accessmonster.com