Thanks PhilModJunk for your advice.
I tried the new formula but it still resulted in the error message appearing regardless of whether they had answered Yes, No or Don't know to 'Pertussis Infection Maternal'. I think i will give up on that and look into script triggers. I have never used scripts before so i'm currently having a play around with them.
Will i be able to have a script trigger that will take them to their next correct field depending on what they answer. I will still need a record of their answer to the first question though. That's why i wasn't using a button.
e.g. if they answer yes to Q1, they proceed onto Q2 but if they answer No or don't know to Q1, they proceed to Q5
Thank you for all the assistance i have received over the last week. i find this forum invaluable.
i have this persistent problem that i haven't tried many different calculations without being able to get the result i require.
I have a field named ‘blood test swab’ (which has 3 options of yes, no, don’t know) and which should only have data entered if the previous field ‘Pertussis Infection maternal’ has been answered ‘yes’. (3 options of yes, no, don’t know). I am wanting to post a message if they try and enter data into 'blood test swab' when not supposed to.
The formula I have used is as follows:
Pertussis Infection maternal ≠ "Yes" and IsEmpty ( blood test swab ) or not IsEmpty ( blood test swab)
which isn’t working as it allows data to be entered into ‘blood test swab’ regardless of what option was entered into ‘pertussis infection maternal’.
I have tried that many variations and nothing works properly.