Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event Help in a Form

Status
Not open for further replies.

quest4

Technical User
Aug 27, 2001
735
US
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.
 
I managed to figure it out. You append it to the end of the validation rule. I would have like to have had two different warning messages, but I guess this will be alright. Thanks anyway.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top