Automatic Data Entry

[JohnL7]

Hi All,

I'm sure this must be fairly straight forward but I've been going around in circles trying to solve it in VBA without success.

I want the value of a field (Field C) on a form to be automatically entered depending on the value of two other fields (Fields A & B).

e.g.
If Field A is Null and Field B is Null then Field C is Null
If Field A is not Null and Field B is Null then Field C = "YES"
If Field A is not Null and Field B is not Null then Field C = "NO"

Please, put me out of my agony!!

John

 

[neileg]

If A & B are null, can we assume that C is null so nothing needs to be done?

If so, the calculated field in the underlying query needs to be:
C: Iif((Not IsNull(A)) And IsNull(B),"yes","no")