Applies To
Form, Parameter query, Report, Select query, Table.
Description
You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied.
Setting
The OrderByOn property uses the following settings.
Setting
Description
Visual Basic
Yes
(Default) The OrderBy property setting is applied when the object is opened.
True (–1)
No
The OrderBy property setting isn't applied when the object is opened.
False (0)
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.
See Also
AllowFilters property, ApplyFilter action, ApplyFilter method, Filter property, Filter property, FilterOn property, OrderBy property.