how do I sort items in a drop down combo box

  • Thread starter Thread starter slateman
  • Start date Start date
S

slateman

This is a simple request. how do I make a dropdown list
display in alphabetical order. It should do it anyway.
 
This is a simple request. how do I make a dropdown list display in
alphabetical order. It should do it anyway.
Click to expand...

If you are using a table as a RowSource change to a SELECT query against
the same table and set a sort order in the query.

If you are using a ValueList you have no choice but to enter the values
in the order you want them displayed.
 
This is a simple request. how do I make a dropdown list
display in alphabetical order. It should do it anyway.
Click to expand...

What is the RowSourceType of the combo? And what is the RowSource?

The most common technique is to have a Table containing the values for the
combo box; but rather than basing the combo directly on the (unsorted) Table,
base it on a Query sorting the records in the desired order.
 
What is the RowSourceType of the combo? And what is the RowSource?

The most common technique is to have a Table containing the values
for the combo box; but rather than basing the combo directly on
the (unsorted) Table, base it on a Query sorting the records in
the desired order.
Click to expand...

The advantage there (besides the sorting) is that you don't have to
edit the form to change the dropdown list -- you just add a record
to the source table.
 
Back
Top