getting combobox to sort in alphabetical order

  • Thread starter Thread starter chang
  • Start date Start date
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.
 
Add an Order By to the Row Source property of the combo box. This is a basic
sql/query.
 
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.
 
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
 
Back
Top