Filling Combobox with cobobox.SelectedValue
I'm looping through a table and using concatenation to display tow fields in the combobox. (Example, Firstname Lastname) "John Doe". I'm setting my displaymember = the concatenated string "fullname". I'm setting my valuemember as "firstname" only. So when I selected "John Doe", I'm only wanting "John" to appear in the combobox text. This is what I'm having trouble doing, what am I doing wrong or can this even be done?
cbo1.text = "John Doe"
cbo1.text = ""
cbo1.text = cbo1.selectedvalue ("John")
The combobox still displays "John Doe" and NOT just "John". Any ideas????
Thanks in advance!