Order By in Form properties

[striker73]

I am trying to change the ordering of entries in my form by using the "Order By" field as part of the form properties. I have tried entering the field name (ie: MethodDesc), but that doesn't work. I also tried entering "MethodDesc ASC", but that didn't work. Any ideas? I could change the RecordSource to a query that is already sorted, but I think that might affect other areas of my form. Help!

 

[PHV]

You must also set the OrderByOn property to true.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[striker73]

Awesome, that worked! I didn't see that as a form property, but I was changing it with VBA anyway, and it was listed as a property there. Thanks!