Limit subform combo box by selection in parent combo box 
Author Message
 Limit subform combo box by selection in parent combo box

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.

Sat, 16 Nov 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Populate a combo box from another combo box selection

2. Combo box selection narrows next combo box choices

3. Limiting Access to Text Boxes, List Boxes and Combo Boxes

4. Can't get Combo Box selection into Text Box

5. List Box & Combo Box selection notification

6. enter data in a combo box based on value from another combo box

7. Want Access combo box to filter rowsource of another combo box

8. Populating a combo box from another combo box

9. selecting records for 2nd combo box dependant on first combo box

10. Help filling second combo box from fist combo box

11. load 2nd combo box - depend on first combo box

12. Setting Combo box ListIndex initiates Combo box Click event


Powered by phpBB® Forum Software