Form Fields not Refreshing

Is this a LiveCycle form or an Acrobat Form? What do you mean by "refresh"? Do you mean calculations?

This is an Acrobat form created in Acrobat Pro 7.0 on the Mac. The problem I am having is that the calculations are not refreshing after I modify a field in the middle of the "equation."

I am creating a leave of absence form that has 12 rows, one for each month, and 5 columns. Column 1 has monthly beginning balance (days vacation), # earned this month (which is a set number that doesn't change, # days used, dates, and balance forward (days carried over to the beginning balance column for the next month.

The user enters in their initial beginning balance manually. From then on, it is calculated for them automatically. They enter the number of vacation days used each month manually. In the balance forward column, I have a sript that does a calculation that subtracts the number of days used minus the number of days you started the month with plus the number of days you earned that month. The calculation work perfectly the first time through. But, if I go to the middle of the year and change a variable, only 1 or 2 calculations are refreshed and the final totals are incorrect. It is as if I need to create a total form recalculate button or script to run after each modification.

Does that help? If not, I will gladly send the form to you.

Thanks.

sounds like you need to set the "calculation order". This is of course really, really, important in getting the calculations right and it's an option on one of the Acrobat Menus. I don't remember wich one, but you can easily look it up in the Acrobat Help.

What you need to do is set the field calculation order in Acrobat 5 you do this by going to Tools -> Forms -> Set Field Calculation Order