getting combobox to sort in alphabetical order

C

chang

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.
 
D

Duane Hookom

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

Reggie

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.
 
L

Larry Daugherty

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
 
Top