Sorting of Query in subform doesn't happen

[Compressor]

Hi,

I have a query for a subform which is displayed in datasheet mode (see attachment). I've created a form based on a query and used it as a subform.
The "casenumbers" per clients are displayed from 1 and upwards, I would like to have them sorted Descending. So in the query I sorted them that way. When I run the query they are displayed in descending order. When I open the subform based on that query however it is not. I can sort descending anyway by clicking the column on which I want to sort and do it that way, but that becomes bothersome and it doesn't need to be that way.

Record source is ok:
SELECT KlantNAW.ClientNumber, CaseInfoTable.Casenumber, CaseInfoTable.DateInitialCall, CaseInfoTable.DateCaseCreation, CaseInfoTable.CaseAccepted, CaseInfoTable.[1stAppointmentDate], CaseInfoTable.DateCaseClosed, CaseInfoTable.About1 FROM KlantNAW INNER JOIN CaseInfoTable ON KlantNAW.ClientNumber=CaseInfoTable.ClientNumber;

Order by:
Casenumber DESC

I thought, well, lets create a new form based on the query to see if that changes anything, maybe I've changed something I shouldn't have.

But nope, same result.

How can make the form sort descending in datasheet mode?

 

[Compressor]

hmm... strange. When I open the subform "standalone", switch to display in Form mode the records are sorted in the correct (reverse) order, when I then switch back to datasheet view again, the records stay sorted correctly. Why not the first time 'round?

Edit: when I just run the database, right click a column, goto option Subform in the menu, then click form view and in that same menu then click apply filter te results are filtered the way they are supposed to. So somehow the filtering done by the query isn't made active. Don't know if that's true, but that's the way it appears.