Access combo box question?

Question

Here's the situation. I have a a form that should display First, middle, last name, address, city, state, zip, phone from table customers. In the middle of the form is customer subform which shows itemnumber, item, price, quantity and purchase date from another table. The two tables are linked by customerid fields. I created a combo box on the form and want the rest of the form and subform to be populated when choosing the name from the drop down box. I.e, Smith, John will appear in the combo box, and when I click it, I want the entire form to be populated with all linked records.
Any ideas?

Answer 1

use javascript to access the form fields value.