When using a ComboBox to select a lookup value, sometimes, you need to update more than one field in the form with values from the lookup.

Is there a way to access the values of the data in the Internal Combobox BO? or should we just use the PK field returned by the BindingField to look for the data again manually?

Edhy Rijo

I hate to keep coming back with this, but it is not finding any of the columns I setup in the combox.

CType(Me.cboItemName.DataSource, DataTable).Rows(Me.cboItemName.SelectedIndex).Item("ItemPrice")

Here is the DataTable which only shows 3 columns and the column I would like to see "ItemPrice" its value is in the DropDown column:

I already implemented the method of using another BO for lookup, but if this can work, then it will be easier to maintain and re-use in other forms.

Edhy Rijo

They won't be the name of the columns in the combo box.  There will be 2 different columns (just put a break point in your code and look at the columns).  There will be a display and a value column (I think) but it gives you the contents of the combo.  The BO that was used to generate the contents of the BO is long gone by this point, so if you want to get back to that you will have to manually populate your own combo.

Thanks!

Edhy Rijo