sSQL = 'Select Id From Table' Ors.open sSQL,oConnWhile not ors.Eof Combox1.AddItem(oRs.Filed("ID").value) oRs.MoveNext Wend
Combo1.Clear strSql = "SELECT DISTINCT field FROM table" Set rst = ExecuteSQL(strSql, msgText) If Not (rst.EOF) Then For i = 0 To rst.RecordCount-1 Combo1.AddItem rst.Fields(0) rst.MoveNext Next End If rst.Close
Ors.open sSQL,oConnWhile not ors.Eof
Combox1.AddItem(oRs.Filed("ID").value)
oRs.MoveNext
Wend
strSql = "SELECT DISTINCT field FROM table"
Set rst = ExecuteSQL(strSql, msgText)
If Not (rst.EOF) Then
For i = 0 To rst.RecordCount-1
Combo1.AddItem rst.Fields(0)
rst.MoveNext
Next
End If
rst.Close