Oldest month

[lbunch]

I have a form control that to totalforecast and on the

form I have controls for each month

mo1, mo2, mo3 - mo12 as the form controls for each of the 12 months. using

for x = 1-12

is there a way to change the value of each month which I can use *-1 to change value to negative

but the kicker is I need to start with the oldest month first and change values.

After thinking about - that may not be an issue really, but still I would like to know if there is a way.

 

[JerryKlmns]

I don't quit understand what you mean but it could be

For i= -12 to -1

or
For i=12 to 1 Step -1

 

[SkipVought]

Hi,

Please tell us what you are ULTIMATELY trying to accomplish.

I really question have 12 separate forms, one for each month.

I assume that the formats and contol logic are identical. So why MULTIPLY your maintenance eleven times more than need be? Create YEAR & MONTH control and maintain A SINGLE FORM.

Skip,

_[red][/red]