Enum vlues into Combo

[veledrom]

Hi,
Code below retrieves some of the enum values, not all.
Why?
Thanks

Dim RST As New ADODB.RecordSet
Combo1.Clear
RST.Open "Select Distinct Title From MyTable",Conn
If Not RST.EOF  Then    
RST.MoveFirst   
Do While Not RST.EOF
       Combo1.AddItem RST(0) & ""
       RST.MoveNext
   Loop
End If

[QVeen72]

Hi,

It should Retrieve all Distinct Column from the table.. Can you post some Sample data as of what kind of string is left out....?

Regards
Veena

[veledrom]

Hi,

If any of enum value is not recorded ina column then, it doesn't return the enum value. This is what i have find out. Therefore, if table has no record then i can not populate enums into combo.

Thanks