Dynamic change subform chart on tab pages by parameter

[tektipsMem]

I have a form with main chart and subform charts on detail section of several tab pages of the same form. There are parameters on the form header: Start Date, End Date, Choose Unit in text boxes. The chart x-axis is Date (between Start Date and End Date) and y-axis is some numeric values. Sample table from a query:

Unit Date Value1 Value2 Value3

A 01/01/05 0.1 0.5 0.7
A 02/01/05 0.3 -0.5 0.2
A 03/01/05 -0.1 0.1 0.3
A 04/01/05 -0.3 0.1 0.6
B 01/01/05 0.4 -0.3 0.5
B 02/01/05 -0.1 -0.3 0.6
B 03/01/05 0.2 -0.5 0.3
C 01/01/05 0.6 0.2 0.1
C 02/01/05 0.3 -0.1 0.2

So tab page1 would have chart of Date vs Value1, tab page2 would have chart of Date vs Value2 and tab page3 would have chart of Date vs Value3. All pages would be the same Unit, that is, if Unit A is chosen on the parameter, page1, page2 and page3 would have chart of Date vs Value of Unit A only.

I manage to have page1 main chart works with the chosen date range and Unit. Subform page2 chart only respond to chosen date range but not Unit.

Any idea how to make the subform chart change with change of paramter? I am also open to suggestions of different ways of presenting the charts.

Thanks.
TTM [santa2]

 

[tektipsMem]

Hope everyone has a good holiday. I am not sure if my thread had no reply because of the holiday or because I was not clear on my question. In either case, please reply so I will repost the question else where. Thanks.

TTM