Tech Support Forum banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
6 Posts
Discussion Starter · #1 ·
On my form I have created a Combo Box that is based on a small table. The source table has only one column (Field 1) that lists 73 different items that are sorted alphabetically. However, when I select the combo box on the form and the drop down menu appears that lists the 73 items, the items are not listed in alpha order, but listed randomly instead.

How can I make the drop down list sort the items alphabetically, as the underlaying table does?

GG
Houston, TX
 

·
Grammar Nazi!
Joined
·
3,865 Posts
Hi G,

On the Row Source property for the the combo box put in a query like:

Select [Field 1] from [table name] order by [field 1]

of course use your names for the field and table. The "order by " clause defaults to ascending or you can add desc for descending if you want the order reversed.

...order by [field 1] desc

hope that helps
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top