Sorting a combo field in an Access 2003 form

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

Guest

My table that feeds the form's combo box is sorted, but I can't get the combo
field to sort ascending in the form.
Any ideas?
Thanks
 
Sue,
If you are using a table as the RowSource for your combo, try using a
query instead. You can then sort to suit.
Click on the RowSource property, and select tyhe 3-dot button that
appears on the right.
 
Thank you Al. That was quick and easy.

Al Camp said:
Sue,
If you are using a table as the RowSource for your combo, try using a
query instead. You can then sort to suit.
Click on the RowSource property, and select tyhe 3-dot button that
appears on the right.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
 

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 based on the name selected under the combo box 14
Access Form - Lock Fields from Editing 0
*HELP* with sorting in Basicform & Subform.. Access 2010 0
Sort by problem 6
Order By question 6
Making all controls match selection of combo box 0
Sort Form Records Using Field Names from Combo Box 1
OnClick on Combo Box opens a New Form 0

Back
Top