Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box sort
- Thread starter balistikb
- Start date
Do you have them tied to a query or a table? If so then you can go to that underlying query or table and sort it that way, elsewise (new word, lol), you would use SQL.
If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv![[pc1]](/data/assets/smilies/pc1.gif "[pc1] [pc1]")
![[shocked]](/data/assets/smilies/shocked.gif "[shocked] [shocked]")
If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv
- Thread starter
- #3
Well if you have it on a form then all you have to do is go to the Data tab in the Design view properties and go to the control source and in the query change the sort to ascending or descinding, whichever would be your pleasure.
If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv
If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv
AmritPaulSingh
Programmer
If you have a sql as the record source for the combo, then just add "Order By <field>;" at the end of the sql where field is the name of the field that you want the combo to be sorted by.
- Status
Similar threads
- Locked
- Question