I have a form and on one page I have one combo box and four text boxes. The combo boxNumber VacationWeeks, has ficve choices, 0-4. The text boxes are date/time-short formated and are VacationWeek1, VacationWeek2,, etc. I would like to put in a double check so someone couldn't accidently enter to many vacation weeks for an employee. I tried to put, in the Event tab of properties, the following procedures:
VacationWeek1 NumberVacationWeeks=1 Or NumberVacationWeeks=2 Or
NumberVacationWeeks=3 Or
NumberVacationWeeks=4
VacationWeek2 NumberVacationWeeks=2 Or NumberVacationWeeks=3 Or
NumberVacationWeeks=4
VacationWeek3 NumberVacationWeeks=3 Or NumberVacationWeeks=4
VacationWeek4 NumberVacationWeeks=4
Needless to say this did not work, I could tab and enter my way through all of the text boxes regardless of what the setting was in the NumberVacationWeeks. Have I just chosen the wrong event or can someone see something else wrong. Thanks alot in advance.
VacationWeek1 NumberVacationWeeks=1 Or NumberVacationWeeks=2 Or
NumberVacationWeeks=3 Or
NumberVacationWeeks=4
VacationWeek2 NumberVacationWeeks=2 Or NumberVacationWeeks=3 Or
NumberVacationWeeks=4
VacationWeek3 NumberVacationWeeks=3 Or NumberVacationWeeks=4
VacationWeek4 NumberVacationWeeks=4
Needless to say this did not work, I could tab and enter my way through all of the text boxes regardless of what the setting was in the NumberVacationWeeks. Have I just chosen the wrong event or can someone see something else wrong. Thanks alot in advance.