View Full Version : Retrieve value from Combo box


prao
04-16-2001, 04:54 AM
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
04-16-2001, 06:23 AM
Why do you need to populate a temp textbox?

prao
04-16-2001, 06:31 AM
To use the value for some other calculations.

Thanks

Rich
04-16-2001, 08:35 AM
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
04-16-2001, 12:15 PM
Thanks for the solution. I will try it out.