Alphabetical Order!

[Bob]

I have a drop down list that contains horse names from cbhorse how can I
get them to be in alphabetical order

Thanks in advance.........Bob Vance

 

[fredg]

I have a drop down list that contains horse names from cbhorse how can I
get them to be in alphabetical order

Thanks in advance.........Bob Vance

Create a query, sorted by HorseName.
Use that as the combo box RowSource.

 

[Guest]

Go to design view of the form or (shudder) table. At the row source for the
drop down, hit the ... build button. Create a query from cbhorse and sort on
the horse's names. Close the query and use is as the row source instead of
the table.

 

[Duane Hookom]

Add a sorting in the Row Source query for the combo box like:

SELECT HorseID, HorseName
FROM tblHorses
ORDER BY HorseName;