What determines the order in which items are listed in a drop-down list box?

I have a table containing a list of available products. I have sorted the table by writing a new version of the table using a select query, ordered by a field that determines the desired sequence. The records should be stored in the table in the desired order. If I open the table with no index order set, the records appear in the desired order.

I have the combo box's RowSource type set to 6 - Fields and the Sorted property is .F.

When I access the combo box, the items are listed in an order with no apparent relation to the table. Definitely not what I want.

Can anyone give me a clue?

Thank You,
Neil Preston