I have a combobox which is filled with items from a table like this:
For Each rad In interntabell.Rows firstname = rad("firstname") lastname = rad("lastname") id = rad("id") ComboBox1.Items.Add(id & " " & firstname & " " & lastname) Next rad
What Im trying to do is to when I choose one name from the dropdown list the firstname shall go to one textbox1 and lastname go to textbox2. One way doing this may be to use the ID column wich is the the Primary Key. And do a new search in a button with that ID which fills the textboxes. But how can I get just a portion of the selected string in the combobox to a string so I can do a search on it. Desperate for help now, have been searching all over, but cant find anything helpful. Please help me.