Sorting a Combo Box

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

Now that I have figure out using the Not In List event to
add data to a table. How can I have the new data
automatically sorted A-Z for use in the combo box? I want
the data in the combo box to be sorted A-Z. At the moment
it is sorted in the order that I enter new data.

Thanks.

Mike
 
Now that I have figure out using the Not In List event to
add data to a table. How can I have the new data
automatically sorted A-Z for use in the combo box? I want
the data in the combo box to be sorted A-Z. At the moment
it is sorted in the order that I enter new data.

Thanks.

Mike
Click to expand...

The Row Source for the combo box should be a query or an SQL
statement.
Sort the query as wanted, or if it is a SQL statement, add:
Order By [YourField];
at the end of the statement.
 
How can I have the new data
automatically sorted A-Z for use in the combo box? I want
the data in the combo box to be sorted A-Z. At the moment
it is sorted in the order that I enter new data.
Click to expand...

Base the Combo, not on a Table, but on a Query sorted however you
like.
 
Back
Top