Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Order By in Form properties

Status
Not open for further replies.

striker73

MIS
Jun 7, 2001
376
US
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!
 
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
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top