Hello everyone - Great site, great helpers!
Here's a question I haven't been able to find a topic/solution for elsewhere.
I have a form w/Optional Sections -2/page over 10pages. I use Conditional Formatting to not allow the next OpSec appear if the OpSec before it has not been used.
Conditional Formatting:
OpSec(1) = If OpSec(2) is present – Don’t allow insert/delete
OpSec(2) = If OpSec(1) is not present – Don’t allow insert/delete
OpSec(3) = If OpSec(2) is not present – Don’t allow insert/delete
If OpSec(4) is present – Don’t allow insert/delete
OpSec(4) = If OpSec(3) is not present – Don’t allow insert/delete
If OpSec(5) is present – Don’t allow insert/delete
OpSec(5) = If OpSec(4) is not present – Don’t allow insert/delete
OpSec(5) = If OpSec(6) is present – Don’t allow insert/delete
ETC…all the way to OpSec(20)
All seemed fine then for some reason, over and over again it kept replacing chosen fields (OpSec(2)), etc with one OpSec prior.
For instance the ConditFormat for OpSec(5) now reads:
OpSec(5) = If OpSec(5) is not present – Don’t allow insert/delete
If OpSec(4) is present – Don’t allow insert/delete
I keep going back and forth fixing it, saving the form, previewing -then only to find it keeps doing it, to random pages of the form. Most of them (20 OpSec pages) are as I applied the condition, but a few randomly change the field I chose to apply the formatting to.
Any suggestions, it’s very frustrating to say the least!
Thanks -Carole