View Full Version : Descending Sort within Form Properties


trstorer
05-14-2001, 07:38 AM
I want to use the "order by" property within a form. However, I want it to sort in descending order. How do I make that designation? I've tried adding DESC after the fieldname to no avail.

Any other ideas?

Thank you.

charityg
05-14-2001, 08:19 AM
me.orderbyon=true
me.orderby= "fieldname DESC"
should work. were you setting orderbyon=true first?

trstorer
05-14-2001, 08:45 AM
THANK YOU. I added the code to the "On Open" property and it works great.