combo box sort order

P

PattiP

I have a combo box that I would like the pull-down menu to be in alphabetical
order. I originally set the related table up that way, but have since added
items to it. I know how to sort it in the table, but can't seem to find how
to do it, if possible, on the form via the combo box.
 
J

Jeff Boyce

Patti

It sounds like your combo box is based directly on the table.

Create a query that sorts the table values in the order you want. Base your
combo box on that query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
P

PattiP

Thanks, Jeff. Works great!
Yes, I had designed the combo box from the table rather than a query.
 
Top