Pivot chart on form with combo lookup

[MichaelWaimauku]

I have a query that pulls off all items that we have an issue with per quarter per supplier. This is displayed in pivot chart format. I have then inserted that pivot chart into a form.

I put a combo box on the form in the header as a lookup of suppliers based on the query. However, when I select a supplier it doesn't change the pivot chart to just that supplier on the form.

There are 4 fields in the query: NonConformID, Date (Both NonConform table), Supplier (Supplier table), Cause (Cause table)

Any ideas? Help?

 

[JHB]

Do you query have a "Where" selection?

 

[MichaelWaimauku]

Sorry I'm not sure how to implement this? I'd like the user to have a list of suppliers that they could select from and then that returns the pivot chart for that supplier only. It will return the number of products that have been faulty per quarter and per month on seperate forms.