Two fields need info from Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that is providing information for a transaction form. It
has a Vendor Name and a Part Number the Vendor supplies. I need the user to
pick a Vendor/Part Number combination and then update the fields in the
transaction form. I seem to have no problem updating one or the other, but
how could I do both?
 
The value of the combo box comes from the value in the Bound Column. To get
the value of another column in the combo box (this apples to list boxes
also) you need to use the Column property of the box.

Example:
Me.txtTextbox = Me.cboCombobox.Column(1)

The index number of the column property is zero based, so 0 is the first
column, 1 is the second, etc.
 
Back
Top