Stagering loops for refresh on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All~
I am trying to think of a way that I can stagger the refresh of data of
multiple graphs on a single form. Here is what I have so far.

Me!lblQueryTime.Caption = CStr(Now())
If lngCtr = 0 Then
Me!graphAll.Requery
Me!graph1.Requery
Me!graph2.Requery
Me!Graph3.Requery
Me!graph4.Requery
Me!graph5.Requery
Me!LastupdateTime.Caption = CStr(Now())
End If

lngCtr = lngCtr + 1
If lngCtr > 9 Then
lngCtr = 0
End If
Very simple loop query. However what I need to do is stagger the Requery
function for each graph. When I update them all at once the objects on the
form dissapears during the refresh processes. When I only refresh one ata
time the images stay static. How can I requery each of the graphs on an
alternating basis? Any help is appreciated.

Paul
 
webster said:
I am trying to think of a way that I can stagger the refresh of data of
multiple graphs on a single form. Here is what I have so far.

Me!lblQueryTime.Caption = CStr(Now())
If lngCtr = 0 Then
Me!graphAll.Requery
Me!graph1.Requery
Me!graph2.Requery
Me!Graph3.Requery
Me!graph4.Requery
Me!graph5.Requery
Me!LastupdateTime.Caption = CStr(Now())
End If

lngCtr = lngCtr + 1
If lngCtr > 9 Then
lngCtr = 0
End If
Very simple loop query. However what I need to do is stagger the Requery
function for each graph. When I update them all at once the objects on the
form dissapears during the refresh processes. When I only refresh one ata
time the images stay static. How can I requery each of the graphs on an
alternating basis? Any help is appreciated.
Click to expand...


I do not understand what you're doing here, but if all you
want is to run one requery at a time, try this:

If lngCtr = 0 Then Me!graphAll.Requery
If lngCtr = 1 Then Me!graph1.Requery
If lngCtr = 2 Then Me!graph2.Requery
If lngCtr = 3 Then Me!Graph3.Requery
If lngCtr = 4 Then Me!graph4.Requery
If lngCtr = 5 Then Me!graph5.Requery
 
Back
Top