combobox updateing other textboxes

[visualJay]

I would like to use a combo box and have it update the other fields automatically if i choose the name joe from the list i would like it to automatically update the other fields like address state zip, ID# and place them in the new record.

i have a customer table with their information in it
and an invoice table then an invoice_items table

i want my form to show the customer info and be able to update the invoice and the invoice_items table
so far i am using a subform for the invoice_items.

any suggestions.