Use both values from combobox

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

I created a combobox that displays two columns of data. The wizard gives an
option to pass the selected value from one column to another control. I'd
like to take the other column and pass it's data to anothe control or better
yet directly to the database.

Example: I have a dropdown of Products and UPC. Both of these need to be
entered into database from my form but through wizard interface I can only
choose to pass one of the values.
 
I created a combobox that displays two columns of data. The wizard gives an
option to pass the selected value from one column to another control. I'd
like to take the other column and pass it's data to anothe control or better
yet directly to the database.

Example: I have a dropdown of Products and UPC. Both of these need to be
entered into database from my form but through wizard interface I can only
choose to pass one of the values.
Click to expand...

Combo Boxes a Zero based, so
[Products] = Combo ' the bound column
[UPC] = Combo.Column(1) ' the second column
[AnotherField] = Combo.Column(2) ' the third column
etc.
 
Back
Top