Hi
I have created a list box which is populated from a table in a database.
I was wondering if there was a way to order the list by the primary number in the same table?
This is the code which lists the values:
varSQLCmd = “SELECT * FROM Dpt”
varDptRecSet.Open varSQLCmd, varDptConn, adOpenStatic
DptCount = 0
If varDptRecSet.RecordCount > 0 Then
varDptRecSet.MoveFirst
Do While Not varDptRecSet.EOF
lstDpt.AddItem varDptRecSet.Fields(“Code”) & ” – ” & varDptRecSet.Fields(“Dpt”)
DptCount = DptCount + 1
varDptRecSet.MoveNext
Loop
End If
The field in the table which contains the primary ID is named “ID” this is the field i would like the list to be ordered by.
Thanks in advance
Martin
