Charts flashes on and off in Window 2007 but working fine in Windows xp 2003

[jaffar]

Hi guys



I am using access 2003 Professional Edition .I have two form. One is main form and other is sub form. I am displaying chart on sub form. It is working fine on window XP 2003 sp3.

The problem I am having is that when I tested and viewed the charts on window 2007 chart flashes
on and off. It also flashes when i navigate records. When i minimize window and maximize it again it show the chart. I think it is refresh problem. On window 2007 i am using access 2003 Professional Edition. How can i solve it. Any idea

[jaffar]

hi guys


I founded solution by defining global variable for check



Public m_intBMIRefreshCounter As Integer
Behind Current event of form put this
m_intBMIRefreshCounter = 0


and Behind Update event of Graph put this code it will work fine "BMIGraph" will be name of Graph.

Dim p_intLoopCount As IntegerDim objGraph As ObjectDim p_intLoopMaxValue As Integerp_intLoopMaxValue = 2If m_intBMIRefreshCounter = p_intLoopMaxValue ThenElseFor p_intLoopCount = m_intBMIRefreshCounter To 1On Error Resume NextSet objGraph = Me!BMIGraph.ObjectobjGraph.RefreshNext p_intLoopCountm_intBMIRefreshCounter = 2End IfDoEventsSet objGraph = Nothing

Jaffar