OrderByOn Property
You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied. Read/write Boolean.
expression.OrderByOn
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The OrderByOn property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Yes | True | The OrderBy property setting is applied when the object is opened. |
| No | False | (Default) The OrderBy property setting isn't applied when the object is opened. |
For all other objects, you can set the OrderByOn property by clicking a Sort button on the toolbar or by using Visual Basic.
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.
Example
The following example displays a message indicating the state of the OrderByOn property for the "Mailing List" form.
MsgBox "OrderByOn property is " & Forms("Mailing List").OrderByOn