Sorting a drop down list

[Guest]

I have a drop down list on my form that includes
operatorid,lastname and first name. I would like to have
the drop down list be sorted by last name even though the
operatorid is the unique field. How can I show the combo
box on the form in alphbetical order by last name.

Help,
Thanks,
Barb

 

[Albert D. Kallal]

Simply bring up the combo box in design view, and look at the row source for
the combo box.

You can usually click on the [...] button, and the sql for the combo box
will be brought up in the query designer...you can then sort by ANY field in
the table...but not have to display the query.

So, either change the above, or simply builder a query with the sort order
set...and use that for the combo box...

And, hopefully, you are not using the table lookup feature.....you can read
about avoiding this here:

http://www.mvps.org/access/tencommandments.htm