You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied.
Note In a Microsoft Access project (.adp), this property is ignored. To set the sort order, you must use the ServerFilter property.
Setting
The OrderByOn property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Yes | True (–1) | The OrderBy property setting is applied when the object is opened. |
| No | False (0) | (Default) The OrderBy property setting isn't applied when the object is opened. |
For reports, you can set the OrderByOn property by using the report's property sheet, a macro, or Visual Basic.
For all other objects, you can set the OrderByOn property by clicking a Sort button on the toolbar or by using Visual Basic.
Remarks
When a new object is created, it inherits the RecordSource, Filter, OrderBy, OrderByOn, and FilterOn properties of the table or query it was created from.