Stupid VBA/SQL Question

[rendicil]

I want to be able to select a field from a combo box in a form and then have some of the rest of the form update itself with the appropriate records based on the selection from a certain table.

To be a little clearer. I want to be able to select a customer from a drop down box and then have the address fields automatically fill in with the correct shipping and billing info in the order form.

This is all in Access and I'm a newbie to VBA/SQL

 

[tkdkid]

Create a procedure that gets the record and updates the form and call it in the combobox's change event.