Slick graph needs refresh

Disgruntled · March 25th, 2010, 11:29 AM

I have a form that contains some controls that allows the user to basically build a query (pick dates/attributes from a schedule) to update a subform and also build a table.
Also on the form is a MS Graph Chart (MSGraph.Chart.8) OLE object

1. i create a SQL statement that is used as the RecordSource for my subform. this updates my subform ok.

2. using similar data for 1., i create a table called tbl_tempSchedule.

3. my OLE graph chart object has as its Row Source = tbl_tempSchedule.

How can I get my graph to refresh and redraw itself as soon as tbl_tempSchedule has a new set of data?

Please help,
Thank you very much.

Disgruntled · March 25th, 2010, 01:18 PM

I believe i got it to work!

Code:

    'build table for graph
    strSQL_table = strSQL_table & strSQL2
    
    'build record source for subform
    strSQL_subform = strSQL1 & strSQL2

    'update the subform
    Me.sub_TempSched.Form.RecordSource = strSQL_subform

    DoCmd.RunSQL strSQL_table

    'requering the graph so it's redrawn with current data
    Me.OLEUnbound_DayGraph.Requery

Now the only problem i have to correct is that my first row of data is missing in my graph (header line assumed???)

just an FYI
(not so)Disgruntled