Calculated controls

[swas]

Hi,

I have several different forms using subforms in continuous form view. Some
are calculated controls.

I seem to have problems with Access in continual 'Calculating...' mode, with
the form essentially locked up. Pressing F9 stops this, and all is well and
works fine.

As best I can trace it, it is because of the calculated fields, but I can't
see any circulating formulas. For example,

=nz([UnitsOuterLast])*nz([LastOuterStock])+nz([LastUnitStock])

locks up one form as stated. All three parts are fields, not even
referencing other calculated controls (Or vice versa). If I clear this, all
works fine. As with a couple of other forms.

I have had a search of this forum, and others such as
www.allenbrowne.com.au, but can't find any reasonable explanations.

Can anyone help? Should calculated controls be avoided?

Thanks in advance.


swas

 

[OldPro]

Hi,

I have several different forms using subforms in continuous form view. Some
are calculated controls.

I seem to have problems with Access in continual 'Calculating...' mode, with
the form essentially locked up. Pressing F9 stops this, and all is well and
works fine.

As best I can trace it, it is because of the calculated fields, but I can't
see any circulating formulas. For example,

=nz([UnitsOuterLast])*nz([LastOuterStock])+nz([LastUnitStock])

locks up one form as stated. All three parts are fields, not even
referencing other calculated controls (Or vice versa). If I clear this, all
works fine. As with a couple of other forms.

I have had a search of this forum, and others such aswww.allenbrowne.com.au, but can't find any reasonable explanations.

Can anyone help? Should calculated controls be avoided?

Thanks in advance.

swas

Okay, so if you have 40 records displayed on the screen, and each
record calls NZ() 3 times, then that is 120 calls to NZ() every time
you change the master record... have you tried doing it without the
NZ() to see what would happen?