Always Sort Date by Ascending Order?

[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.

 

[Angelsnecropolis]

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.

 

[John W. Vinson]

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.

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