Alphabetical order in drop down list?

[carolineJ]

I have a form called register a new project. One of the fields in the form is called project manager. It is a drop down list and the choices available are taken from a table with all project managers. How ever they are not sorted in alpabetical order so it is really hard for the user to find the project manager he or she is looking for. How can I correct this?

 

[tomschafer]

Make the rowsource of the combo box an SQL instead of a Table. Like...

select
[Project Manager]
from
TableName
order by
[Project Manager]

 

[carolineJ]

Excellent! Thank you!