Descending Sort within Form Properties

[trstorer]

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]

me.orderbyon=true
me.orderby= "fieldname DESC"
should work. were you setting orderbyon=true first?

 

[trstorer]

THANK YOU. I added the code to the "On Open" property and it works great.

 

[fionahl]

Thanks from me too! Works a treat.