Form - Combo box selections change based on previous selection

[Skaven]

Hi,

I'm using Access 2003.

Table:
Parts

Fields
Parts
Customer
Quotes

All of the Parts are unique, however the same customer name may appear on several different Parts records.

Goal:
I need a form with a combo box to select the Customer name from a list (based it on a query that lists only unique customer names)
Once the customer is selected, I want the Parts combo box to list only the parts that the selected Customer purchases and the Quotes combo box to list only the Quotes related to that customer. Once those 3 selections are made, more information is entered by the user and all results are dumped into a new table called TIME (fields - Customer, Part, Quote, Engineer, Action, Time).

I know how to automatically update the Part & Quote fields when the Customer is selected, however it will only display the first Part/Quote record found for that customer.

Is there a way I can automatically generate a query once the Customer selection has been made and have that populate the combo box? I tried using DLOOKUP but it will only return one (the first) value in the Part list.

I have only used Access for very simple things and I can't seem to get this one to work. Please help.

J

 

[Alansidman]

What you are referring to is commonly called cascading combo boxes. Look at this for how to do them.

http://www.fontstuff.com/access/acctut10.htm

Alan