Finding a value in a table based on a value in the combo box

[grenee]

Good Day All,

I have combo box "Combo60" whose record source is a table "Products" with fields "Product name" and "Product code".

The combo box selects the product name only.

When I click button "Code" I want it to launch a message box displaying the "Product Code" which corresponds to the selection of the combo box.

Can anyone provide the solution to this problem.

 

[pbaldy]

Try

MsgBox Me.Combo60.Column(1)

 

[grenee]

Thanks! paul / Baldy. it worked like magic

 

[pbaldy]

Happy to help!