How do I use the MS Forms 2.0 combo box? I am trying to fill the columns with different items. I am trying to order by Last Name, UserID. The Last Name is sorted correctly but the UserID list is sorted in respect to the Last Name and not alphabetically. I want both the Last Name and UserID sorted alphabetically.
Below is the code.
Set rs1 = New adodb.Recordset
FirmSubTemp = "Select UserID, [First Name], [Last Name] from [User ID] where FirmSub = '" & varTemp & "' order by [Last Name], UserID"
'sSQl = sSQl & "Where Name =" & Chr(34) & "Boby's Place" & Chr(34)
rs1.Open FirmSubTemp, conn, adOpenDynamic, adLockOptimistic
Do Until rs1.EOF = True
If rs1.EOF = False And rs1.BOF = False Then
FirstName = rs1.Fields("First Name")
LastName = rs1.Fields("Last Name")
FirstLastName = FirstName & " " & LastName
NameCombo.ColumnIndex(0) = FirstLastName