Problems Updating Graph

[microtoolmaker]

I have a graph embedded in a form that plots a values from calculated fields in a query. The graph needs to be updated after each new record is added. I do not want to link fields since that isolates the graph view to the current record only.<br>
Doing a requery does not help. The only way I've seen this graph update is to close and re-open the form...<br>
<br>
Can anyone help me with this?

 

[Lzorza]

My Friend, you can try to disvinculate the OLE from the graph's base query setting the RowSource property to &quot;&quot; and revinculate it. <br>
<br>
Write the following code at any event procedure that is executed when the new record is added.<br>
<br>
'disvinculate<br>
Forms[Your_Form]![Your_OLE].RowSource = &quot;&quot;<br>
Forms[Your_Form]![Your_OLE].Requery<br>
<br>
'if necessary insert code to update tables or queries <br>
'used in the Graph_Query_Base <br>
<br>
'revinculate <br>
Forms[Your_Form]![Your_OLE].RowSource = &quot;Graph_Query_Base&quot;<br>
Forms[Your_Form]![Your_OLE].Requery<br>