Using Setvalue macro in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Back
Top