Lookup and return value code

[LewisKing]

In my form I have a combo box (Item) with 3 columns
Item, itemnumber, and CaseCost

I have another textbox control named CaseCost.

What i need to have happen is for the CaseCost to populate itself based on whatever item is selected from combobox item. That is, if the user selects Item A,Afterupdate, corresponding CaseCost A is input into the CaseCost Control.

 

[Remou]

You can use the Column property. Numbering starts from zero.

[tt]=Me.Combo.Column(2)[/tt]