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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Query to limit selections on a pulldown 6
Conditional Pulldown List??? 1
Pulldown List to open Workbook. 2
VLOOKUP using a list not in alphabetical order. 3
IE history pulldown is broken 8
Help with a form/query 1
Combo Box, list order 3
Show more categories in the pulldown menu 1

Back
Top