Hello, I have a form (frmDecisionTree) with several Yes/No field types as check boxes.
I want three of these fields PPopulation DDesign1 and D2Design2 to control the result of a field called NDE. If all three of these are unchecked then I want it to record NDE. If that isn't the case then I want the value to be null. Can anyone help with the syntax of this and let me know if I should be using afterupdate?
Private Sub NDE_AfterUpdate()
If qryDecisionTree.[PPopulation] Is False And qryDecisionTree.[DDesign1] Is False And qryDecisionTree.[D2Design2] Is False Then qryDecisionTree.NDE = NDE Else NDE Is Null