N
nicksneath
I have a suppliers subform within a products form.
The product code is the unique reference, and there are multipl
suppliers supplying the same product.
I would like to filter the suppliers in the subform – to see whic
products they supply.
When I apply the filter I only get one name (as it is filtering fro
within the products form, not the suppliers). I want to see all th
products supplied by that one supplier.
I want to see it instantly –like you would when filtering a form.
Do I have to set up a macro to achieve this?
Please help if you can - Nic
The product code is the unique reference, and there are multipl
suppliers supplying the same product.
I would like to filter the suppliers in the subform – to see whic
products they supply.
When I apply the filter I only get one name (as it is filtering fro
within the products form, not the suppliers). I want to see all th
products supplied by that one supplier.
I want to see it instantly –like you would when filtering a form.
Do I have to set up a macro to achieve this?
Please help if you can - Nic