sort order

JJ

Registered User.
Local time
Today, 00:38
Joined
Mar 25, 2000
Messages
10
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?
 
Is your recordsource for your subform a query and is the date used as a parameter within your query? If so, then you must create an additional field within your query referencing the date field and use this new field in your subform. Set the new field to the sorting requirements that you want in your query. This should solve your problem.
Good Luck
 

Users who are viewing this thread

Back
Top Bottom