Hello all,

I have two fields in my table (tblChangeControlFormDetails). OtherRequestor and Requestor.

I want to have only and only one of these two fields to have value. In addition, both fields cannot be Null at the same time. That is, if OtherRequestor have an input, Requestor field should be blank and vice verse.

I did not set any validation rule for OtherRequestor. I try to put a validation rule for Requestor but Access Database was not happy about it. Here are my attempted validation rule

(Is Not Null & [OtherRequestor] = Null) Or Is Null

I have also tried

[OtherRequestor]=Null

Nothing works.

Any help is most appreciated it.

Thanks

A statement that will work as well try using only one statement the nz() function:

Requestor: nz([OtherRequestor],[Requestor])

Just a suggestion..