Access 2013: Table List resort on form

CMILLER
CMILLER used Ask the Experts™
on
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?
Combo-Box-Info.PNG
Comment
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
Commented:
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.

Author

Commented:
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