value from combobox

[maro009]

hi

i have a combobox
row source is :
SELECT Customer.Customer_id, Customer.CustomerName FROM Customer ORDER BY [CustomerName];

now how can i return the customer_id from the selected row

example combobox

customerID | customername
1 | mike
2 | Kyle
3 | Rita

now i want have a varaible assigned to the selected customer id

how can i do this ?
thx

 

[PHV]

I guess you're with msaccess, don't you ?
Have a look at the BoundColumn property of the ComboBox object.
Set this property to 1 (one) and then:
yourVar = Me![your combo].Value

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