I am trying to limit the list in a subform combo box by the selection in a
combo box on the main form - Access 97
eg. "Orders" sample database

Create a combo box on main form from Categories table called
SelectCategories. Then
limit the subform combo "ProductID" to products in the Category selected in
SelectCategories combo box.

I am able to select all products but when I add a criteria to Categories in
the ProductID Combo Box the subform combo box does not return any records.

Your assistance would be appreciated.