Northwind Orders Subform Question

[Guest]

On the Northwind Orders Subform, you can select from a list of products. What
is the best way to select the product category first (from a drop-down list)
so that the displayed list of products are only those from the selected
category - a separate query, subform within a subform?

 

[Allen Browne]

The simplest interface probably involves a combo where the user can select
the categories. Whether this is in the subform, on the main form, or on a
popup form is up to you, but you will use the AfterUpdate event procedure of
this category combo to set the RowSource of the ProductID combo.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm