Perfect - Thanks.

Daryl S wrote:
szag -

Put a space between the fieldname and Desc:

Me.OrderBy = "[Vendor_JE] Desc"

I am struggling with creating commdand buttons for sorting on a field. Here
are the codes in the two buttons:
[quoted text clipped - 10 lines]
button working and how to do clear out the OrderBy in the forms property.
Thanks!

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