Datasheet sorting not working

[Sofo]

I have set a datasheet to be sorted descending on a date in the sorted by field of the Data tab, but the sort isn't performed when i open the form.
What can be wrong?

 

[statsman]

If you are running your form from a query, sort in the query.

 

[Sofo]

Thanks. Unfortunately i am not running it from a query. It is a subform in datasheet mode.

 

[missinglinq]

You need tomake a query of the table, sort the query by the desired field, then base the subform on the query.

 

[Sofo]

Solution.

Found a simple solution: Simply add 'SORTED BY fieldname DESC' (or whatever wanted) to the select statement that populates the datasheet.