Populated results from combobox to textbox ?

[dibblm]

I'll start this hopefully simple and add code where needed or requested.

Im using a combobox that bound to a DataSet. The Dataset retreives it's values from SQL.

I can retreive the values fine. However only displaying (1) Column. Which is fine.

Here's where it gets complicated for me. The dataset has 2 other columns that get filled. I need the resulting columns to be sent to text boxes when I select a value from the combobox.

Basically:

 txtbox1.text = combobox.column(2).selectedvalue
 txtbox2.text = combobox.column(3).selectedvalue

However. using the method of course doesnt work and that's what I need to figure out.

[dibblm]

Figured it out myself after days of searching. Here's what I did.

OK. For anyone looking for this in the future let me tell you how I went about this.

I filled the DataSet with Data From SQL. Bound a ComboBox to the DataSet.

 txtbox1.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

 txtbox2.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

First issue I ran into was VB sending errors because the first column was yet to be populated so I had to set the index of cbox1 to 0

 cbox1.selectedindex = 0

Then for the selected index chage event

If cbox1.selectedindex = -1 then
  cbox1.selectedindex = 0
end if

txtbox1.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

txtbox2.text = dataset.tables("table name here").Rows(cbox1.selectedindex).Item("Column name here")

Thats all there was too it. being a novice I was actually trying to get the data from the Column instead of the Row. "STUPID. Yes.."

If anyone wants to modify and tell of any other way we can make this better I would appreciate it.

[Xennex]

Seems like you were able to solve your problem well.. I tend to favor using the "With" statement when I have long object strings since each '.' is basically telling an object traversal.. I would just change the following like so:

With dataset.tables("table name here").Rows(cbox1.selectedindex)
   txtbox1.text = .Item("Column name here")
   txtbox2.text = .Item("Column name here")
End With