Refresh data in continuous form

[Guest]

Hello!

I have a continuous form with fields in row and sum in text box (right cell).
When I change data in fields data, the sum cell don't change.
Only actualize value, when click F9.
Why?

Thanks in advance.
an

 

[Michel Walsh]

Hi,



Because Access is not a spreadsheet. F9, manually, or Me.Recalc, through
VBA, would force to update the formula.


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Thanks for your reply.
I tried trought Event Procedure in On click and On Key Press but don't Recalc.
an

 

[Guest]

Ok, MW.

Applied in all cells, work fine.
Many thanks for your help.
an