Sorting Combo Box List

[jrmbach]

I have an Expenses form that has a Vendor field. It's a lookup combo box. The control source is a table "Vendor" The table has an Auto Number field "VendorID followed by a Text Field "VendorName". I update the Vendor table with a form "frmVendor". Whenever I pull down the Vendor field list in the Expenses form it is sorted by Vendor ID, not Vendor Name even though I have sorted the Vendor table by Vendor Name. How can I get the pulldown list sorted by Vendor Name?

[pbaldy]

Click on the ellipsis next to the table name in the row source property. Confirm you want to create a query, double click on the ID field and then the text field to make them fields. Put a sort on the text field.