Hello All,
I have a database and I want to show users a pop up if there are any negative responses to questions in the form.
I have a form that contains a subform depending on which subform is chosen. I have the onload functionality on the subform. (I have also tried it on the main form but the same thing happens)
When I load the form after inserting a negative answer the first response is picked up but it doesn’t notify about other negative responses.
Here is my code for onload
@If(
Radio2=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 2”);
Radio4=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 4”);
Radio5=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 5”);
Radio6=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 6”);
Radio7=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 7”);
Radio8=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 8”);
Radio9=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 9”);
Radio10=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 10”);
Radio11=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 11”);
Radio12=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 12”);
Radio13=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 13”);
Radio14=“Yes”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 14”);
Radio15=“No”;@Prompt([Ok];“Error!”;“There is a non standard answer for question 15”);
“”)
So it picks up that the first radio button has a no answer but not that the second one or any other subsequent ones. What do I need to do to get it to pick up all the negative answers in the database on opening?
Thanks in advance,
Laura