Sort combo box?

R

Rick

I have a combo box on a form, the info in the box is
looked up from a table. My problem is I want the list to
be sorted a-z but it shows up in what ever order that the
info was typed into the table. (I have sorted the table A-
Z and saved it but combo box on the form still does not
show up sorted)can anyone help me here?

Thanks Rick
 
K

Ken Snell

Use a query as the Row Source for the combo box, and put the desired sort
order in the 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

Similar Threads

Sort with Combo box 2
Combo Box and First Record 5
Sorting Combo Boxes in a Form 2
Combo Box Sorting and Selecting 4
Sorting a Combo Box 2
combo box filter 1
Update combo box 2
Blank combo or list box 1

Top