How to set sequence a subform's Datasheet

[Dean Slindee]

I have a subform that is displaying with a Datasheet Default View property.
The Record Source for the subform is a table.

In the subform's "Order By" property I have specified the following
"TestDate DESC". TestDate is a column in the table named as the Record
Source for the subform.



Problem is, the Order By property is being ignored. Is the Order By only
valid on main forms?



Thanks in advance.

Dean S

 

[John W. Vinson]

I have a subform that is displaying with a Datasheet Default View property.
The Record Source for the subform is a table.

In the subform's "Order By" property I have specified the following
"TestDate DESC". TestDate is a column in the table named as the Record
Source for the subform.



Problem is, the Order By property is being ignored. Is the Order By only
valid on main forms?

No, but you must set the Subform's OrderByOn property to True (in code, it's
not exposed in the form properties).

In general it's a lot simpler to just base the form on a sorted Query (rather
than on a table). This won't interfere with updating, and (if the sort field
is indexed, as it should be) won't noticably affect performance.

John W. Vinson [MVP]