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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Form Validation of one field based on value of another
I ended up making B a check box, so I set the If to be If B = -1 then if IsNull([B1]) then Cancel=True msgbox "must enter a value for B1" Exit Sub end if if IsNull([B2]) then Cancel=True msgbox "must enter a value for B2" Exit Sub end if end if and it almost...- dcrake
- Post #5
- Forum: Microsoft: Access Forms
-
Form Validation of one field based on value of another
How do I make access validate the value of one form field based on the presence of data entered into another form field. Specificaly, I have data entry form (called CORR-001) which contains 8 fields (A, A1, A2, A3, B, B1, B2,B3). When field B has a value (not null), I want to require that...- dcrake
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
