Lookup list sort

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

Guest

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).
 
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.
 
Back
Top