Sorting criteria will not work with new records

[JOE]

I’m having a sorting by date crisis. I use a query as the form recordsource
and have set the sorting order in the query criteria in the date field in an
ascending sorting order so that the source and the form has no interference.
However, unlike the old records, the new records entered are not adhering to
the Ascending order desired. I also set the Order By property of the form to
the date field desired. What can I do? Help…!

 

[JOE]

Although I never had to re-query the form in the past, this too did not hold
the sort order.