Filtering using combo boxes

[Markvand]

Hi everyone,

Here is what I have, I have a list of products they come from different vendors and they're grouped by categories.

What I want to do is:

1. list them with the index number and name of the product, group and vendor, which is easy at my level of Access knowledge

2. and here is a problem, I want to narrow the search with combo boxes, eg. list one group of products from a particular vendor (2 combo's)

3. and list it in the other combo box

Is it possible?

Any help on this would be much appreciated.

Thnx

 

[pbaldy]

You want to choose a vendor in the first combo and have their products in the second? Search here for cascading combo boxes; it's been dealt with many times.

 

[Markvand]

Not really, vendor in one, group in second and the narrowed results in third. Thus, cascading combos might not work, but I am not sure