updating a chart on a form when data on a subform changes

[raddrummer]

I'm sure this is probably really easy but it's hanging me up so I'll go ahead and ask the question.

I have an unbound form that contains a subform containing query results in tabular format.

I want a chart on the main form that updates itself based on the currently selected record in the subform.

So far I've tried using the refresh method placed in the on change() event of the subforms properties box but nothing happens.

[ADezii]

I'm sure this is probably really easy but it's hanging me up so I'll go ahead and ask the question.

I have an unbound form that contains a subform containing query results in tabular format.

I want a chart on the main form that updates itself based on the currently selected record in the subform.

So far I've tried using the refresh method placed in the on change() event of the subforms properties box but nothing happens.

1. Base the Record Source of the Chart on a Subset of the data that is the Record Source for the Sub-Form. If the Sub-Form's Name is tblTest, create the Chart using several Fields from tblTest.
2. Copy and Paste the Record Source of the Chart to the Current() Even of the Sub-Form adding a WHERE Clause to regenerate the Chart for a specific Field Value in the Current Record.
3. In my testing, the Value of the [Delivered_Date] Field in the Sub-Form is used to redraw the Chart for the Current Record in the Sub-Form (Notice the added WHERE Clause).
4. Ignore the Field Names used for testing, they were only used for testing and are meaningless in the current context.
   

   Private Sub Form_Current()
   Me.Parent![<Your Chart Name Here>].RowSource = "TRANSFORM Sum([Ver_Number]) AS [SumOfVer_Number] SELECT " & _
               "[Delivered_Date] FROM [tblTest] WHERE " & _
               "[Delivered_Date]=#" & Me![Delivered_Date] & "#  GROUP BY [Delivered_Date]  PIVOT [DashNum];"
   End Sub
    

5. I realize that my explanation is very clumsy, and I do apologize for it, but there seems to be no easy way to explain how to accomplish this. All I can tell you is that it has been tested and is fully functional.
6. If I can further assist, please feel free to ask
7. Basically, you are changing the Row Source of the Chart in the Current() Event of the Sub-Form based on a specific Field Value in the Current Record.
8. I think I better quite while I'm ahead at this point. (LOL).

[tezza98]

when you select the the record you need to pass the record values to the chart, you can pass them in different ways depeding on how the chart works, but basically you need to chart values to point to the record values, so you need to pass the record values from the subform, maybe using the onclick or ongotfocus method, pass the values to the chart variables, and then refresh the main form or chart.

check out this site for more detailed info about accessing form and subform properties and controls from a subform or form
http://www.mvps.org/access/forms/frm0031.htm