ordering forms bacwards

[CALV]

HI all,

GOt a subform on a main form in continuous form view, all working fine (almost!!) but the subform is in order of ID (autonumber) I would like this in REVERSE order, is there a way to do this ?

TIA

CALV

 

[jfgambit]

If your subform's Record Source is built from a Query, you can go into the design mode of the query (under the subform Properties) and in the "Sort" Row of your ID Column change it to "Descending".

 

[casey]

Use querybuilder on the recordsource of the subform.
If you've added * fields from the table to your query, add the autonumber field to the query separately , then uncheck its Show property and set its Sort property to descending. (Both properties can be found in querybuilder). You are adding an extra field to the query which is unseen and is merely used to sort the results the way you want them.

If you've added each field individually to the form's query, then find the autonumber field and set its Sort property to descending. (In this scenario, you have the field already available so all you need to do is to have it sort the autonumber field descending.

HTH