Want Access combo box to filter rowsource of another combo box 
Author Message
 Want Access combo box to filter rowsource of another combo box

In an detail section of an order form for a store with
several hundred products, I need to use a control to
select the desired product category, of which there are
20, and have that selection filter the product records
shown in a combo box. I have written source to alter the
row source property of the products combo box, using an
unbound combo box in the detail section of the form.

The problem is, when you change the product category,
every line in the detail section of the form shows the
newly chosen category, when I only want it to apply to the
currently selected line.

Using a 'categories' combo box in the form header would
work, but would make a really awkward interface for users
because you would have to bounce back and forth from
header to your product line, resetting the category each

Any ideas?

Tue, 27 Sep 2005 23:24:10 GMT  
 [ 1 post ] 

 Relevant Pages 

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

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

3. Limit subform combo box by selection in parent combo box

4. Populating a combo box from another combo box

5. Populate a combo box from another combo box selection

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

7. Help filling second combo box from fist combo box

8. Combo box selection narrows next combo box choices

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

10. Setting Combo box ListIndex initiates Combo box Click event

11. combo box/database combo box vlaue question - newbie

12. Combo Box like Data Bound Combo Box?


Powered by phpBB® Forum Software