Pivot table subform giving me grief

[rhino213]

Help me! I'm creating a supplier database at the moment. I have a pivot table that allows users to filter the list of suppliers by programme, primary product & company name. I'd like to make it so that double clicking on a company name opens that suppliers details in a new form (which I have already made). How do I do this?

While the knowledge is flowing, I'd also like to make a button that will reset/remove the filtering from the pivot table. Any idea's?

Thanks guys!

 

[rhino213]

Bump! - Any ideas folks? The boss is on my back now!

 

[Rich]

Use the command button wizard to build the code for you, just copy it to the double click event of you control, remember to delete the button and code behind it

 

[rhino213]

Thanks Rich!

Only problem with that is.....

It works in form view but not in pivot table view. I'm using a pivot table view because i like the way it allows you to filter the lists. I'm open to other ways of doing this though if anyone can think of any.

I'll try to explain myself a bit clearer. I have 3 lists on my pivot table (programme, primary product & company name). I want to apply a filter to each of these lists that will narrow down the list of suppliers to a particular group of companies that were involved in programme X, making product Y. (X & Y are chosen from the filters that appear at the top of each list on the pivot table).

Any idea's?

I'm also after a button that will clear the filtering each time it is clicked? (At the moment the pivot table seems to remember the filters you apply.

Thanks again Rich. Thats a big step in right direction!