Always Sort Date by Ascending Order?

  • Thread starter Thread starter Angelsnecropolis
  • Start date Start date
A

Angelsnecropolis

I have a date field on my form. When I apply filters to other fields on the
form they become disorganized by date. Of course I can always manually
right-mouse click and choose ascending order by is there a way to make this
field always in Ascending order even after other filters have been applied?
Form code or property maybe?

Thanks.
 
Nevermind. I figured it out. I had to set the Date field in my Table to sort
by ascending order and save the Table properties.
 
Nevermind. I figured it out. I had to set the Date field in my Table to sort
by ascending order and save the Table properties.
Click to expand...

Better would be to base the Form on a query sorting by the datefield. Tables
aren't actually sorted (except temporarily for display purposes).
 
Back
Top