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…!

 

[Linq Adams via AccessMonster.com]

Are you requering the form after adding the new record? Until you do this,
the sort order you've set in the query won't take effect

Me.Requery

will requery the form's recordsource, and solve your problems, I suspect.

 

[JOE]

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