Sorting Records in a Look Up Field

[galegiegerich]

I have a table with the key field being an autonumber and another field as name field. From this table I have a query that contains all the fields from the table. From this query I have built a form (with subforms) that contains fields from the query. One of the fields in the form is created as a look up field allowing me to pick one of the "names" from the table. The look up list is sorting by key field (autonumber) and I would like for it to sort alphabetically. What do I need to change to get this to happen? Thanks again for everyones help.

 

[llkhoutx]

The recordsource for your combo box should be a query, with the aulphanumeric field sorted.