Access 2013 Expert 7 Lesson 3 (Time Index 4:09) -  I'm using Access for a property management business for Homeowner Associations. I have an Association table and a Vendors table. They have a many-to-many relationship.

I followed the example in the lesson to set this up and it works just like the example in the lesson with Customers and Groups. On my Association form, I have a Vendors subform which has a combo box of vendors sorted by vendor name. The list of vendors when you click on the combo dropdown box IS in alphabetical order. But the vendors in the subform are not. I see that the customers in the lesson also are not in alpha order. As I add vendors, they seem to go on the subform in ID# order.

Is there a way to get them listed alphabetically by vendor name on the subform? It's difficult to locate a specific name if there's a long list.
Thanks,
Betti

---

Reply from Alex Hedley:

You could add a SORT or ORDER BY to the Query that is the RecordSource of your SubForm.