Combo box order

I use a simple table (One text field) for a drop down in a combo box that is
a "Failure Description". I cant seem to find a way to alphabetize the order
of the drop down. Yet when I look at the table, it is in Alpha order?
--
Thanks for any assistance

Change the Row Source to a query that is based on your "Failure Description"
table, and use an ORDER BY clause in the query to present the list items in
the desired order.
--

Ken Snell
MS ACCESS MVP

"NNlogistics" wrote in message
...
I use a simple table (One text field) for a drop down in a combo box that
is
a "Failure Description". I cant seem to find a way to alphabetize the
order
of the drop down. Yet when I look at the table, it is in Alpha order?
--
Thanks for any assistance

As always, thanks Ken. I thought that would be the answer, it just seems
that we waste a lot of space. Now I basically have a duplication of a table
and a search probable is done on the table as well as the query. I quess in
todays technology thats not an issue.
--
Thanks for any assistance


"Ken Snell [MVP]" wrote:

Change the Row Source to a query that is based on your "Failure Description"
table, and use an ORDER BY clause in the query to present the list items in
the desired order.
--

Ken Snell
MS ACCESS MVP

"NNlogistics" wrote in message
...
I use a simple table (One text field) for a drop down in a combo box that
is
a "Failure Description". I cant seem to find a way to alphabetize the
order
of the drop down. Yet when I look at the table, it is in Alpha order?
--
Thanks for any assistance

I don't understand what you mean by "duplication of a table". A Row Source,
even when you select a table name from the dropdown list, is still using a
query to get data from that table --- you just don't see it in the Property
window.

Using a query to obtain and order data is the *right* way to do what you
were asking. Good luck.
--

Ken Snell
MS ACCESS MVP


"NNlogistics" wrote in message
...
As always, thanks Ken. I thought that would be the answer, it just seems
that we waste a lot of space. Now I basically have a duplication of a
table
and a search probable is done on the table as well as the query. I quess
in
todays technology thats not an issue.
--
Thanks for any assistance


"Ken Snell [MVP]" wrote:

Change the Row Source to a query that is based on your "Failure
Description"
table, and use an ORDER BY clause in the query to present the list items
in
the desired order.
--

Ken Snell
MS ACCESS MVP

"NNlogistics" wrote in message
...
I use a simple table (One text field) for a drop down in a combo box
that
is
a "Failure Description". I cant seem to find a way to alphabetize the
order
of the drop down. Yet when I look at the table, it is in Alpha order?
--
Thanks for any assistance