pulldown list in ascending order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

HT

Perry Kerr
 
Set the RowSource to
SELECT A,B FROM T ORDER BY B
if B is the one 2 sort

HTH
Pieter

rawley said:
I have a list of defects (~10). I have just added the 11th, which is
Click to expand...
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?
 
Back
Top