Sorting a Combo Box

[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

 

[fredg]

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

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.

 

[John Vinson]

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.

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