I have never seen a listbox behave like this without some underlying form code change to the sort order. I suspect that is happening here with the altered sort order being on SGID, which would indeed put those two rows at the end.
Excess Access
Windows 11 
Access 2019
I have never seen a listbox behave like this without some underlying form code change to the sort order. I suspect that is happening here with the altered sort order being on SGID, which would indeed put those two rows at the end.
Me.Dirty=True
Windows 11 Office 365
Have you tried deleting and re-creating the listbox?Definitely seems like something with the ListBox.
What happens if you add even more records? Do they sort correctly with the other 2 still out of order?
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
VIP
Windows 10 Access 2007
Show us your event tab. I agree, more going on here than you are letting on/aware.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Virtually Inert Person
Windows 10 Access 2016
In case no one has suggested yet - compact/repair & zip a db copy and post it. If necessary, you can strip out all the private stuff, make it smaller by removing reports & stuff not needed.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Access 2016 using SQL Server 2016, Multi-user, query to run Stored Procedure
Properly Displaying Special Characters in ListBox
Reports not sorting properly
Time not Sorting Properly in Report
Posting Permissions
Reply With Quote