I have a Form where the user inputs some info. I am wanting to validate that all 3 of the boxes are completed before it allows them to proceed.
I know I can just do 3 If statements but the other day someone (I think it was Mbiz but could be wrong) used an example of a putting another text box that the value in that single text box gets switched from "Yes" to "No" using something like Switch(nz(xxx), "xxx", nz(yyy), "yyyy", nz(www), "www", true, "Yes", "No")
I attempted with just two variables but.... all I get is "Yes" regardless of if it should be "yes" or "no"
Actually the three fields I have to test are:
This was my feeble attempt: