Sort Sub Form in Descending Date Order

[Dalkeith]

Usually to sort a Form in a particular order you go to the forms section and within the SQL write a statement showing the information in descending order.

I have a subform however and the subform does not appear in the forms section.
Fine I can go into objects and select the subform here and I note that there is a tab called display and on selection it has a SQL box.

I am wondering whether I have to define the SQL in a specific way so it that it not only arranges the sub records in a descending date field order but also filters out only children of the parent form.

Could someone who know more maybe give some air code or give some guidance?

Many Thanks

Mark

[Dalkeith]

My first thought was I just completely omit the select section of of the SQL and simply place in Order by clause

Code: Select all

ORDER BY DATEUPDATED DESC

That didn't seem to work

[Dalkeith]

Apologies discovered how to do it.

Access Sub Form via Objects button.

Go to Subform tab and here you will see the entire SQL already defined.

Alter the SQL as required.

Thanks everyone for brilliant and easy product

[admin]

Cool!