I have a subform that I want to sort in descending order by the date. I can accomplish this just fine in the subform. However, when I open the main form, for some reason the subform loses its sort order and defaults to ascending. How do I make the subform maintain the sort order when it's opened in the main form?