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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.