Select/display data using a datacombo

I have an access database containing a customer table (name, address,city phone etc).

I would like to create a form containing an ado datacombo box as the drop down selection for the customer name, and then text boxes for the other fields in the table.

I have managed to bind the datacombo to the ado control - and the drop down displays all the customer names.....however when I select a name from the list, the data in the text boxes does not change. The text boxes are bound to the ado - and display the first record data

I think I have to have some code in the OnChange sub for the datacombo - and have tried, for example, adodc1.recordsource = "select * from Customer where cust_name = dcoCust_Name.text and then adodc1.refresh

but nothing happens....in fact the adodc1.refresh throws an error!

Can anyone suggest how I can make this work.

many thanks
Suep