Sorting ComboBox Entries

[reaktorblue]

I have a cascading combobox that I would like to have sorted in ascending order. For my first combobox, this was easy because I could simply select the ellipsis of the row source and change the value of sort to ascending.

The second combobox however is derived from the after update event of the first combobox. Since I'm using this method, there is nothing actually in the row source property to enable sorting in ascending value. I think I'll need to add this to my code below.

Does anyone happen to know what code would allow this to be sorted in ascending order?

    Select Case cboCategory.Value
        Case "Leadership Call"
            cboSubCategory.RowSource = "tblLeadershipCall"
        Case "Coaching"
            cboSubCategory.RowSource = "tblCoaching"
        Case "Technical Issue"
            cboSubCategory.RowSource = "tblTechnicalIssue"
        Case "Attendance"
            cboSubCategory.RowSource = "tblAttendance"
        Case "Other"
            cboSubCategory.RowSource = "tblOther"
    End Select