Alphabetical Order!

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
Click to expand...

Create a query, sorted by HorseName.
Use that as the combo box RowSource.
 
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.
 
Add a sorting in the Row Source query for the combo box like:

SELECT HorseID, HorseName
FROM tblHorses
ORDER BY HorseName;
 
Back
Top