OrderByOn Property

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.