Full Version: Validation Rule
UtterAccess Forums > Microsoft® Access > Access Forms
amexm
How to write the "Validation Rule" for:
If Field A equals "No" then Field B must be blank.
Thanks.
freakazeud
How about using code instead e.g.:
If Me.YourControlA = "No" Then
Me.YourControlB = null
End If
You could use this on the after update event of the A control.
HTH
Good luck
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.