ComboBox Columns

[Shiner452]

I have a combo box that displays 3 fields...when a selection is made on
of the field is stored in a different table. I would like to be abl
to store 2 of the fields in the combo box into the same table.

That is one of my options...my other option is...

to have two seperate combo boxes. When one selection is made on on
box the other combo box will show the corresponding field value.
have been able to set up a form to work this way with the code:

Private Sub cboItem_Change()
Let cboStockNumber.value = cboItem
End Sub

This works and shows the fields corresponding values but only when th
combo boxes are unbound. When the combo boxes have a control sourc
this same code causes each combo box to show the same exact value, no
the corresponding field value. Any help at all would be great.
Thanks