Pulling data from a table/query based on combo box selection in fo

[Guest]

How can I setup a form so that when a selection is made from a combo/list
box, other fields are automatically filled in based on a table or query?

For example, I have a table that contains customer data. I want to be able
to select a unique identifier (customer email) in a form and have the
customer's name, address, phone, etc. automatically filled in within the form.

I also want to be able to edit the imported information if possible to
update it if anything has changed.

Thanks!

 

[Rick B]

That is one of the built-in functions of a combo box. If you use the
wizard, it is one of the three options that you are presented with (option
3).


1. I want the combo box to look up the values in a table of query.
2. I will type in the values I want.
3. Find a record on my form based on the value I selected in my combo box.