General information
Category:
Forms & Form designer
Title:
Combo Box list order?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only