hello!
for example i have tblInfo and a field name LETTERS and has values a,b and c
i used below code but it olny add the "a" value on th combo box
not the 3 letters

rs.open " SELECT LETTERS FROM tblInfo", con, adOpenDynamic, adLockOptimistic
If rs.EOF <> True Then
combobox1.AddItem rs.Fields(0)
End If
rs.Close