sorting a subform

[whitestone]

I need to order a sub form (which is a continuous form) by a Date field in decending order (so that the latest date appears at the top).

When I open the subform on its own the sort works fine by just sorting using the OrderBy property but when it is opened as a subform it doesn’t sort in the same way.

help

 

[Rich]

Use the Order by property of the subform's underlying query