Is there anyway to sort the data in a combo box. I created a table with our store numbers in it. When I pasted them into the table they were not in sequence. I sort the table and save it, but my numbers in the combo box are the way I originally pasted them. I can repaste them sorted and everything is fine. But it would seem I should be able to sort this in a property of the combo box.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting data in a combo box
- Thread starter rss01
- Start date
It's simple. Just make your sort part of the row source of the combo box.
Go to the properties of the combo box and click the "..." button next to the rowsource property. In the query view that pops up enter in the sort that you need. Maq B-)
<insert witty signature here>
Go to the properties of the combo box and click the "..." button next to the rowsource property. In the query view that pops up enter in the sort that you need. Maq B-)
<insert witty signature here>
- Thread starter
- #3
- Status
Similar threads
