Sorting NotInList combo box lists

[Robert C]

I have a combo box with a NotInList event running on it which takes and sends information information to a table of product Categories. There are quite a few product categories and it would be useful for the list on the Combo Box to be sorted alphabetically. Does anyone know how to do this.

Many thanks in advance

 

[AlaskanDad]

By what you've written, the NotInList part really has no bearing on your sorting needs. For the RecordSource on the combo box, you will want to click the "..." to the right of it. Access will ask you if you want to build a query. Click OK and you will go the query design view. Select the Category column you want to display and select Ascending in the Sort row. Close this window and you will be asked if you want to save the results. Click OK and you're done.