Filtering Graph(s) by single user selection (1 Viewer)

Fozi

Registered User.
Local time
Today, 08:58
Joined
Feb 28, 2006
Messages
137
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

Wino Moderator
Staff member
Local time
Today, 01:58
Joined
Aug 30, 2003
Messages
36,118
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

MVP / VIP
Local time
Today, 08:58
Joined
Jan 14, 2017
Messages
18,186
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
 

Attachments

  • Capture.jpg
    Capture.jpg
    53.8 KB · Views: 202

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:58
Joined
May 7, 2009
Messages
19,170
what is that
 

Users who are viewing this thread

Top Bottom