If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
getting combobox to sort in 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. |
#3
|
|||
|
|||
getting combobox to sort in 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. |
#4
|
|||
|
|||
getting combobox to sort in 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Wrong sort order of report's details section | dsjohn_242 | Setting Up & Running Reports | 6 | July 12th, 2004 10:21 PM |
Inhereting the sort order | Dan St.John | Setting Up & Running Reports | 1 | July 9th, 2004 03:30 AM |
Need help putting sort order back | ismegordo | Worksheet Functions | 1 | April 1st, 2004 03:13 AM |
X Axis Sort Order | Jason | Charts and Charting | 2 | October 9th, 2003 04:12 PM |