One can't get much simpler than "this" (pics below) yet when the combo drops down the list is not sorted according to the RowSource query.
I'm assuming the problem is staring me right in the face but I'm not seeing it!
(It shouldn't matter, but the combo control is made visible just prior to the dropdown.)
What am I missing? (Besides a few brain cells here)