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
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