Combobox to change value of other text box's.

[parslow]

Hi there,



I am fairly new to Access, Im just wondering what the best approach would be to go about the following,

I have 1 drop down combobox that has a list of Customer Names, I then have a text box for their Address, Suburb & Postcode, now what I am trying to do is make the Address, Suburb and & Remarks fields automatically update when Customer Name is selected. All this information is stored in a table called Customers if this is of any use.

Any help anyone could provide would be greatly appreciated.

Parslow

[tzh1600]

Create a query with your RecordSource and join Customer Names Address, Suburb & Postcode & etc from your Customers table link with Customer Names or CustomerID(ID is correct), NOW Use this query to be yours new RecordSource