Using Setvalue macro in a form

[Guest]

I have a form where i am using a Setvalue macro. For example:

value1
value2
Sum

I have tried using On Enter, On Exit, On Focus to calculate Sum
(Sum=value1+value2).

If I enter value 1 and value2 and Tab/Enter through Sum, nothing happens.

If I enter value 1 and value2, and then click on Sum and then do a Tab, it
sometimes populates.

In other cases, I need to click twice on Sum before it populates. (I am not
using On Click or On Dbl Click event)

Any ideas?

 

[Allen Browne]

See:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html

The article explains how and when to store a calculated result.