Here is a modified version of your form. .... with a few suggestions:1.
You shoudl always name your subforms. I changed your untitled subforms
to page1, Page2 ..... this makes things easier to follow when error
messages are generated.2. I did the 1st calculation in the table on page
2. By putting it on the Calc event a dependancy is set up between this
field and any field named in the calc. So when any one of those fields
changes the script is executed.3. I use a For loop to loop through each
ro...