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

Fozi

Registered User.
Local time
Today, 06:33
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
Yesterday, 22:33
Joined
Aug 30, 2003
Messages
34,217
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

CID Moderator
Staff member
Local time
Today, 06:33
Joined
Jan 14, 2017
Messages
13,401
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

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom