I am trying to create YTD fields on a form. I unchecked the field on Reset Form but they are still getting reset. What can I do?

[micheller78368722]

I am trying to create YTD fields on a form. I unchecked the field on Reset Form but they are still getting reset. What can I do?

[try67]

Are you setting their value with a script? If so, make sure you also set the default value to the same string. Then they will maintain their values even when reset.

[micheller78368722]

Here is the script I am using to calculate the YTDAmt total.

(AmountRow1 + AmountRow2 + AmountRow3 + AmountRow4 + AmountRow5 + AmountRow6 + AmountRow7 + AmountRow8 + AmountRow9 + AmountRow10 + AmountRow11 + AmountRow12 + AmountRow13 + AmountRow14 + AmountRow15 + AmountRow16 + AmountRow17 + AmountRow18)

[gkaiseril]

It might be more helpful if you posted a link to your form or a form with a similar problem.

We need to understand what each field you are adding represents.

[micheller78368722]

Here is the form.

[micheller78368722]

Calculation for YTDAmt

[micheller78368722]

Here is where I tried to retain the YTD Amounts.

Not sure how to add this code to Default Value.

[Bernd Alheit]

Do you reset all other fields?

[gkaiseril]

There are many possible errors and you have not provided enough information to limit the number of possabilities.

How are you calculating the YTD value?

There are 3 possible answers.

Want is the result you are getting?

[micheller78368722]

The 2nd screen shot above is the way I'm calculating the YTDAmt.

YTDAMT  then Properties then Calculate. The I keyed in the above

code in the simplified field notation.

AmountRow1 + AmountRow2 + ...

Its adding the fields together okay but I need to retain the

YTDAmt for the following month.

[gkaiseril]

Your approach might not be the best. If you are going to sum up the months activity along with the previous months YTD value in the YTD field, then every time one adds a daily entry the YTD will be added into it. I would look at have having a second YTD field for the previous month and adding that to the  month's activity to creat the new YTD field. This will keep the previous months YTD value unchan ged as new values are added within the month to get to the current YTD value. You will have develop some mechanism to start a new month's sheet with the prior month's YTD value.

[micheller78368722]

I understand what you are saying. Is there a way I can import that into the current sheet?

Is there a way to save that value somehow? Or maybe create a link to it?