Query Auto Refreshing????

  • Thread starter Thread starter Rog
  • Start date Start date
R

Rog

I have a complex query that takes several seconds to compute. Every time I
move the window that it is in it seems to recalculate itself. Is there any
way to stop this behaviour please.
Ta, Roger.
 
Yes - in fact it is when I move another window over the window displaying
the query. It looks as though the query is recalculating as it redraws the
data in the window.
Regards.
Roger.
 
I think that is a feature rather than a bug! If the focus has gone to
another window, the form has no way of knowing that the other window
hasn't done something to change the data returned by the query - it
almost _has_ _to_ requery when it gets the focus back.

Yes - in fact it is when I move another window over the window displaying
the query. It looks as though the query is recalculating as it redraws the
data in the window.
Regards.
Roger.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Can I 'turn off' the recalc like in Excel??

Peter R. Fletcher said:
I think that is a feature rather than a bug! If the focus has gone to
another window, the form has no way of knowing that the other window
hasn't done something to change the data returned by the query - it
almost _has_ _to_ requery when it gets the focus back.




Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
Click to expand...
 
I don't believe so.

Can I 'turn off' the recalc like in Excel??
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top