Using code instead of form calculations

pablavo — Wed, 17 Jun 2009 09:19:43 GMT

Hi there,

I'd like to ask for some advice. On my form there are several text boxes that calculate the variance of two other text boxes. I've added the calculation's by going using a command button and rules and inserting the calculations that way. When the command button is pressed, all of the calculations will be made and the results showen in the appropriate text boxes. This can take some time and I was thinking, if the calculations where in code this would be faster?

When the command button is pressed, it triggers the code and the calculations are made within vbscript or whatever.

Will this speed up the calculations?

I appreciate any help on this. Thanks

Code

Using code instead of form calculations