G
Guest
My form is unbound as are two controls. User inputs data into each control.
I wish to calculate the sum of the two and using VBA test for value, sucha as:
If (me.MyCntrl1 + me.MyCntrl2) > 2 then
perform task
End If
I created a third control with the source "=([MyCntrl1]+[MyCntrl2])". I did
this to check results and, frankly I don't understand. I got the following:
Desired: 1 + 3 = 4
Got: 1 + 3 = 13
Is there something I missed or a workaround?
In hopes of help...
I wish to calculate the sum of the two and using VBA test for value, sucha as:
If (me.MyCntrl1 + me.MyCntrl2) > 2 then
perform task
End If
I created a third control with the source "=([MyCntrl1]+[MyCntrl2])". I did
this to check results and, frankly I don't understand. I got the following:
Desired: 1 + 3 = 4
Got: 1 + 3 = 13
Is there something I missed or a workaround?
In hopes of help...