Getting the second value out of bound combobox 1

[tprscott]

I have a combobox that I want to be populated based on a field in a table called SI. To do this i set the control source equal to the SI. I also want values in a lookup table to appear in this drop down too. So to do this, I have a query in the row source that returns two fields ( one is the SI and the second is a nomenclature). Ideally what I want to do, is when a user selects a field in the combobox i need to fill a text box with the second value in the drop down which is the nomenclature. I also want the nomenclature and SI to match for the old data. I want to bind the drop down to the SI but I want to print the nomen in the nomen text box. Is there a way to do this? Thanks in advance. If you need more clarity let me know I will try to reword this.

 

[PHV]

In the Current event procedure of the form and the AfterUpdate event procedure of the combo:
Me![nomen] = Me![combo name].Column(1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886