getting combobox to sort in alphabetical order

I have set up a combobox to pull up a record, but when i enter new records
the combobox updates, but it doesnt sort it, how can i get it to be sorted
into alphabetical order.

Add an Order By to the Row Source property of the combo box. This is a basic
sql/query.

--
Duane Hookom
MS Access MVP


"chang" wrote in message
...
I have set up a combobox to pull up a record, but when i enter new
records
the combobox updates, but it doesnt sort it, how can i get it to be sorted
into alphabetical order.

chang, design a query with the fields you want in your combox. Set the
sorting on the fields you want and save the query. Set the combox to row
source type = table/query and the row source = the query you just created.

--
Reggie

----------
"chang" wrote in message
...
I have set up a combobox to pull up a record, but when i enter new
records
the combobox updates, but it doesnt sort it, how can i get it to be sorted
into alphabetical order.

Hi Chang,

In the properties of the combobox click on the ellipsis (...) to the far
right of the RowSource property. That will bring up the QBE grid. If your
table isn't showing, click Show Tables and select it. You'll need to drag
the fields that you want in the combobox down to the lower section in the
order that you want them in the combobox. Make sure that one of them is the
field by which you want to sort. Click in the Sort field and choose Alpha.
Close the QBE form and answer yes to saving the changes. Answer no to
creating a named query in the query window.

HTH
--
-Larry-
--

"chang" wrote in message
...
I have set up a combobox to pull up a record, but when i enter new
records
the combobox updates, but it doesnt sort it, how can i get it to be sorted
into alphabetical order.