Multiple Combo Boxes in a query?

[Guest]

Hi guys, please help.

I have two tables, Orders and OrderDetails

I want to be able to query an Order and its Details based on 2/3 combo
boxes, for example:

I want to be able to first select the Customer from a list of all customer
who have placed orders, then I want the next combo box to show a list of all
Item_Types that the customer selected in the first box has ordered. I want
that Order and its OrderDetails to be displayed below the form. How do I do
this?

The important field names are as follows:

Orders
--------
OrderID
Customer
OrderDate

OrdersDetails

 

[Guest]

hi,
this is what i know as cascading combos.
see this site. it has example code.
http://www.mvps.org/access/forms/frm0028.htm
this site has downloadable sample dbs
http://www.rogersaccesslibrary.com/TableOfContents3.asp
scroll down to cascading combos
this should fix up your combo boxes.
As for the last part, the query, i would guess use a
simple select query triggered by a command button that
uses the combo boxes as criteria.
good luck.

 

[Jeff Boyce]

Richard

Try creating a form that has those combo boxes on it. Then create a query
that refers to the values in the combo boxes to get its criteria/parameters.