Combo lookup based on previous selection.

P

Pete

I have a customer database (i.e standard Name/Address/Contact)

I have a form, where a combo box is displayed and you can select the
customer. The full details of the customer are displayed when selecting the
combo box, but not after the item is selected (is it possible to display the
Full Details on the form/linked to the customer database)

Each customer, may then have several sites. Is it possible to bring up a
second combo box to select the site (this would need to be filtered based on
the previous customer selection), and add a new site if required?
 
A

Allen Browne

Yes, you can use a similar technique to filter or find the record on the
AfterUpdate event of the second combo.

For an example of how to use the AfterUpdate event of the first combo to
filter the second one, see:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm
 
Top