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

On Fri, 3 Mar 2006 10:30:26 +1300, Bob wrote:

> 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Bob" wrote:

>
>
> 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
>
>
>

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

SELECT HorseID, HorseName
FROM tblHorses
ORDER BY HorseName;

--
Duane Hookom
MS Access MVP
--

"Bob" <(E-Mail Removed)> wrote in message news:du7o5g$e3q$(E-Mail Removed)...
>
>
> 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
>