Retrieve value from Combo box

[prao]

Can somebody help me with this. I have a combo box in a form and it has 2 columns (cust_id and customer_name). The combo box will display only the customer name.
The 2 columns are not bound to any column in the form. When user selects a value from the combo box, I need to populated a temporary text box with the cust id and customer name of the selected row.

 

[Rich]

Why do you need to populate a temp textbox?

 

[prao]

To use the value for some other calculations.

Thanks

 

[Rich]

Set column count to two on the controls property sheet, set column widths to 1;2.5 both columns should now display, to use either in an expression [comboname].Column(0)
where column 0 is the first column

 

[prao]

Thanks for the solution. I will try it out.