Lookup list sort

[mandsogdon]

I am setting up a new database and am wondering how to sort a lookup list
after adding new value. I have a list of job titles, with the primary key as
an autonumber, so in the lookup field the titles are sorted by the autonumber
- I want to put them in alphabetical order (sort ascending).

 

[Allen Browne]

Create a query into the lookup table.
Drag both fields - the number and the text - into the output grid.
Use the Sorting row in query design to sort by name.
Save this query, as use it as the RowSource for your combo.