Using a cono to populate difrent form

[John thomas]

Hi Ihave Form called surveys which contains survey info. I want to populate this form with the customers details from the customer details Table .
Iam using a combo box to select the customers surname but when clicked it only brings across the surname and no other dtails such as address

 

[pbaldy]

Like this?

http://www.baldyweb.com/Autofill.htm

 

[John thomas]

Thanks very helpfull

 

[pbaldy]

No problem.