I have an Access form with a history subform embedded in it. The history subform consists of years, 2001, 2002, 2003. When someone renews a membership, I add the year to the subform. Always before the year went at the bottom of the subform and stayed there. For some reason the last few entries I made puts the year in the penultimate row, not the final row. I haven't made any changes to the program, so I don't know why this is happening. 2021 should not come before 2017, for example.
I am using Access 2016 on a Windows 10 on a PC.