Filtering Graph(s) by single user selection

[Fozi]

Hi folks

I have an unbound form that contains three graph objects - Graph1, Graph2 Graph3.

Each graph serves as a dashboard report and is linked to individual queries, each containing a field called 'Academic Year'.

I would be grateful for pointers on how I can set the form up so that the user enters a value for the academic year and each graph is then filtered to match the users selection.

I know I can enter specific parameters to each of the graphs queries however I want to avoid the user having to enter this once for each graph.

Grateful for any assistance offered.

Thanks
Fozi

 

[pbaldy]

I would put a textbox on a form for the user to enter their selection, and have the queries point there. Could be a dropdown, to limit them to valid selections.

 

[isladogs]

Here's an example showing how I do something similar with various combo boxes which can be used individually or in combination with others

This only has one chart but I have other forms with several different charts controlled in the same way

 

[arnelgp]

what is that

 

[isladogs]

what is that

Who and exactly what are you asking?