update text boxes

[w0od0o]

Hi all,
I am try to show the data from a table based on a selection from a combo box which i assume is pretty simple but just cant find a solution.

for example i have a customer table and a invoice table, when i open an invoice form i want to select a customer name from a drop down menu which will then display the address and tel number etc from the customer table.

thanks for your help

w0od0o

 

[vbaInet]

Have a look into subforms. Your subforms will contain the customer's details and would be linked to the main form which holds the customer's names combo box.