forms and combo boxes

[GRM-kenyette]

Hi,

How do i use a combo box to list all the records from a particular field so that when you select a item from the list it then populates other text boxes on the form relating to that particular record?

For example, if i have a customer table and i have 100 records. I want to put all the names in a combo box and when you select one it displays all the other information in text boxes (such as address, tel No, email address...etc).


thanzs in advance

 

[JammyG]

I would have though you could do that by having the Customer ID in a drop down box, but displaying the Customer ID as the Customers name. How you dislplay the ID as another field I don't know, been told it's possible but I need to find out too !