To Display Correct data on Form or Report

[JustMe]

I hope Someone can help.

I have a form that I built that I an trying to have 2 Combo boxes on it to
get , and display data fro 2 different tables.

In the first Combo box I want to select a customer from the customer table
and then display the usual data on the form of address, city state, and zip.

On the second I want to select a Project ID which will then display the
needed info from that table such as project manager, and project name.

Can someone tell me what code is needed to display the customer data after I
select the correct customer.

Many Thanks

 

[Allen Browne]

You want to use an *unbound* combo box at the top of the form so you can
select the customer and move to their record? There is a combo wizard to
help do that, or use the code in this article:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

I think that's what you are asking. If you were asking how to select a
customer in a bound combo (foreign key) and display details of the customer,
the Orders form in the Northwind sample database shows how to do that. It is
a matter of basing your form on a query that has the Customers table also so
you can read the fields from there.