Access 2013: Table List resort on form

CMILLER used Ask the Experts™
I have a form that has a drop down combo box attached to a table and when I add something to that table, how do I get the combo box to resort A to Z so they are in order in the combo box?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Generally, you would use a query as the rowsource for the combo, something like:

SELECT [ModelName] FROM tbl_Model ORDER BY ModelName

Otherwise, the ModelNames will be displayed in the order that they were added to the table.


To Easy, Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial