combo box sort order

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

Guest

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.
 
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
 
Thanks, Jeff. Works great!
Yes, I had designed the combo box from the table rather than a query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top