| | |
|
|
|
pulldown list in ascending order |
|---|
| message from =?Utf-8?B?cmF3bGV5?= on 11 May 2004 |
I have a list of defects (~10). I have just added the 11th, which is right in the middle of the list, alphabetically. However, this shows up in the form (pulldown menu) in the order the codes were entered (by CodeID). How can I alter the form so that this pulldown shows the list in alphabetical order?
Thanks!
|
| =?Utf-8?B?UE1L?= replied to =?Utf-8?B?cmF3bGV5?= on 11 May 2004 |
I am assuming that this data is held in its own separate table.
Just add an autonumber field to the table, then construct your combo box with the fields sorted by the autonumber. To hide this field you can set the width of that column to 0.
HTH
Perry Kerr
|
| Pieter Wijnen replied to =?Utf-8?B?cmF3bGV5?= on 11 May 2004 |
Set the RowSource to
SELECT A,B FROM T ORDER BY B
if B is the one 2 sort
HTH
Pieter
"rawley" <anonymous@discussions.microsoft.com> wrote in message
news:3E24D505-C922-4789-9779-A223F7871929@microsoft.com...
right in the middle of the list, alphabetically. However, this shows up in
the form (pulldown menu) in the order the codes were entered (by CodeID).
How can I alter the form so that this pulldown shows the list in
alphabetical order?
|
| =?Utf-8?B?cmF3bGV5?= replied to =?Utf-8?B?cmF3bGV5?= on 11 May 2004 |
That'll work...thanks for all of your help!
|
|
Archived message: pulldown list in ascending order (Microsoft Access Forms)
