Look table out of order

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

My lookup table is sorted alphabetically when I look at it alone, but when
it is displayed within the combo box of the the column that is using it as a
lookup, the order seems random. How can I get it to show alphabetically
within the combo box?

tia
las
 
if you created a Lookup field in a table, i recommend you get rid of it. see
http://www.mvps.org/access/lookupfields.htm for reasons why.

if you're talking about a combo box in a form, you can set the sort order in
the RowSource property. if your RowSource is the name of a query, you can
open the query in design view and set the sort order the same way you always
would. if your RowSource is a SELECT statement, click on the RowSource line
and you'll see an ellipsis (...) button at the right side. click the button
and you'll see a box that looks like a query design view. set the sort order
just as you would in a query, close and save. then save the form.

hth
 
Back
Top