lookup fields in alpha order

[glenda laliberte]

I have set up a form for data entry, one field of which is
a drop-down list from another table which has about 1000
recored in it. I want the drop-down list to be presented
in alpha order, but so far can only get it to show up in
the order in which the records were entered. Tried
sorting that field in that table, but it didn't change
anything. Please help.

 

[Guest]

Try basing your form off a query instead of a table. For
the query, just choose all and sort ascending on that
column.

 

[John Vinson]

I have set up a form for data entry, one field of which is
a drop-down list from another table which has about 1000
recored in it. I want the drop-down list to be presented
in alpha order, but so far can only get it to show up in
the order in which the records were entered. Tried
sorting that field in that table, but it didn't change
anything. Please help.

Tables have no order. They're unordered "bags" of data.

Create a Query based on the lookup table, and specify the desired sort
order in this Query; and use that Query as the rowsource of your combo
box.