Calculating....non stop

[Guest]

kindly help me in this issue....

i have Form (Datasheet view) showing total query..result
when i run...i see calculating ....in the bottom...and if i click on the
form it stops.

how can i eliminate this.....

in the form one of the text box control source is formula which gives me
previous record.. this is the reason.

Thanks in advance.

 

[Allen Browne]

It is quite easy to trigger this kind of endless recalculation.
It might be the way your form is referring to the previous row.

If any controls have conditional formatting, temporarily remove that to see
if it makes a difference. Particularly with calculated fields, CF can do
that.

Code in the events of the form can also trigger this behavior.