Updating a chart with a button

[kentclub]

Hello,


I have a chart that gathers its information from a query.

What the chart shows is the number of businesses for each month over the year (I have a table with a list of businesses that each have a date).

I have added a "next" and "previous" button and a label on the chart : so if the label shows "2014", when you click on "next" it becomes "2015".
Now I need to be able to also change the chart so that it actually takes the year displayed in that label and shows the businesses for each month that year.

Would you happen to know how ?



Thanks !

[June7]

The chart's RowSource can have a dynamic filter criteria that references the label (this would usually be a textbox).

Example from my db:

SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];

[kentclub]

Hi,

I've managed to enter the code in the query generator but now nothing changes when I change the year (by pressing the button to switch to 2015, 2016 etc...)

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.