Updating Months criteria

[lbunch]

Ok, this one I need some help on to see if it makes sense and can even be done in Access.


I have a form control with 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 keep the user from adding to amounts in past months.

Since it is September the users cannot increase the totalamounts combined in months 1-8
and if it was October the users cannot increase the totalamounts combined in months 1-9.

 

[SkipVought]

Hi,

YOU are the programmer.

YOU are in control.

Question: Can a user view forms for more than one month SIMULTANEOUSLY? Probably not. So why have 12 forms, one for each month? Make the MONTH a criteria selection and maintain ONE FORM.

BTW, you will probably get better Access Form specific answers in the Microsoft: Access Forms forum702

Skip,

_[red][/red]