I have a ListBox on my Access form to find and select a record from the bound table. Here is the ListBox's RowSource:
If I execute that query in the query window, I get the following result (which I've scrolled a bit to show pertinent records):Code:SELECT SGID, SGGroupName, SGCategory FROM tblSGroups ORDER BY SGGroupName;
When I view the ListBox on the form, I get the following (also scrolled to the right entry):
Note the 2 entries at the end are out of order. I can't figure this out. Why would 2 random records show up out of order?
They ARE the last 2 entries I put into the table, but they should be showing alphabetically, right?
Any ideas? Thanks...