Combo box order

N

NNlogistics

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

Ken Snell [MVP]

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

NNlogistics

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

Ken Snell [MVP]

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