combo dropdown display not sorted

[GraeagleBill]

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)

[davegri]

Make your row source
SELECT * from QTTypes ORDER BY TType;

[GraeagleBill]

I tried that first before I created a query but that didn't work either.

Still scratching my head

[davegri]

I tried that first before I created a query but that didn't work either.

I assumed that QTTypes was the query.

If this isn't working are you sure that you aren't changing the row source in code somewhere?

If you run the query on its own, is it sorted properly?

You could bypass the query

SELECT TTypeID, TType FROM tblTTypes ORDER BY TType;

[GraeagleBill]

If this isn't working are you sure that you aren't changing the row source in code somewhere?

Good thinking! I haven't been "under the covers" of this app in a very long time and completely forgot that there is another context within the app that the combo is used. With a simple search among the code therein lies a change to the RowSource.

Thanks,
Bill