Howdy!

I want to put more than one field from a DB in a combo box. I am using the standard combo box control. How do you do it

This example puts the 'pipe sign between, but I want to see seperate fields.

example:

cmb1.clear

Do While Not Adodc1.Recordset.EOF
vntTemp = Trim(Adodc1.Recordset.Fields(0))
vntTemp2 = Trim(Adodc1.Recordset.Fields(1))

cmb1.AddItem (vntTemp & "|" & vntTemp2)
vntTemp = ""
vntTemp2 = ""

Adodc1.Recordset.MoveNext
Loop


Thanx