Dear Doug:
This has worked for me:
In the property sheet for the form when you select the Data tab, there is a row called "Order By". Put your cursor in that field and press F1. You should get the following info from "help". The OrderBy property is a string expression that is the name of the field or fields on which you want to sort records. When you use more than one field name, separate the names with a comma (,).
When you set the OrderBy property by entering one or more field names, the records are sorted in ascending order. Similarly, Visual Basic sorts these fields in ascending order by default.
If you want to sort records in descending order, type DESC at the end of the string expression. For example, to sort customer records in descending order by contact name, set the OrderBy property to "ContactName DESC".
You can set the OrderBy property by using the object's property sheet, a macro, or Visual Basic.
So, in the row "Order by" just enter the name of the field that will govern the way your records appear.
(If no record shows up, then put this in the Default Value of the property sheet of the control itself: [TheNameOfControl].[ItemData](0)
Works for me. Good luck
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.