Combo box order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
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>
 
Back
Top