Access 2013: Table List resort on form

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?
Who is Participating?
Dale FyeCommented:
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.
CMILLERAuthor Commented:
To Easy, Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.