Autofill multiple form fields based upon user selection

I have two tables (1) Customers and (2) Orders. The Customers table
stores information on the customers (e.g. company name, address, phone
number, etc.) and the Orders table stores information on customer
orders. I've created a form based upon the Orders table. I want the
user to be able to select a customer and that customer's information
to be automatically filled into the form.

To do this, I used a Combo Box. The Row Source for the Combo Box
selections is from the Customers table. In the Order form I set the
After Update of the customer Combo Box to:

CustomerAddress = Customer.Column(1)

And I set the Control Source of the CustomerAddress field to:

Customer.Column(1)

How can I have additional form fields automatically filled based upon
the Combo Box selection (e.g. city, state, zip etc.).

Thanks!

.

Relevant Pages

  • Re: Autofill multiple form fields based upon user selection
    ... Relational databases are intended to minimize redundancy, ... included a "foreign key" field that can be used to join with the Customers ... The Row Source for the Combo Box ... selections is from the Customers table. ...
    (comp.databases.ms-access)
  • Re: Autofill multiple form fields based upon user selection
    ... included a "foreign key" field that can be used to join with the Customers ... do need to capture and save it. ... stores information on the customers (e.g. company name, address, phone ... selections is from the Customers table. ...
    (comp.databases.ms-access)
  • Re: Form Help
    ... where a person has to make the different selections and just only those ... If you have a parent/child form with a parent form showing the ... In the customers table there ... a button it would just give me all women at age30 with city of chicago. ...
    (comp.databases.ms-access)
  • Re: Filling in a field based on data in another table
    ... Make the Custeomr_Number entry into a combo box with with the second column ... of the Row Source returning the Customer_Name. ... >I have two tables: purchase_orders and customers. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Auto Fill II (for Access 2002)
    ... name in several different tables populate text boxes within the same form. ... The combo box is pulling information from a table titled "customers" wich ... you can put all the fields that you want to see in the combo box's Row Source ... phone number is in the fifth column in the query use Column). ...
    (microsoft.public.access.forms)