N
nojyttap
I have 5 optional sections to record revisions to the form. The fisrt section
may be entered without restrictions. The 2nd to 5th section cannot be entered
until a checkbox in the previous section is TRUE.
Once the checkbox in a section is TRUE that section and the controls inside
are locked and cannot be changed or deleted.
There may be an easier way but this is how I did it:
There are 5 hidden text boxes (rev1OK, rev2OK, etc.) that start with a value
of 2 (except for revOK1 which starts with 0). When the checkbox in the first
section is TRUE rev1OK is set to 1 and rev2OK is set to 0. This works the
same for the subsequent sections (rev2OK = 1 and rev3OK = 0, rev3OK=1 and
rev4OK = 0).
In the first section the conditional formatting is 'rev1OK = 1 do not allow
users to insert or delete this control. In the second section the conditional
formatting is 'rev2OK not= 0 do not allow users to insert or delete this
control. The subsequent section has similar conditional formatting.
When I first set this up it worked as I expected.
BUT...when I reboot my computer and try to use the form these sections do
not behave properly...some sections open when they shouldn't others won't
open at all.
Here is what I found, the conditional formatting in the first section is
"rev4OK = 2", the second section "rev4OK = 1", the third "rev5OK = 2", forth
"rev5OK = 1" and fifth "rev1OK = 1"
This only happens after a reboot. If I just close and reopen the form it
does not change. PLEASE HELP! How do I prevent this from happening?
may be entered without restrictions. The 2nd to 5th section cannot be entered
until a checkbox in the previous section is TRUE.
Once the checkbox in a section is TRUE that section and the controls inside
are locked and cannot be changed or deleted.
There may be an easier way but this is how I did it:
There are 5 hidden text boxes (rev1OK, rev2OK, etc.) that start with a value
of 2 (except for revOK1 which starts with 0). When the checkbox in the first
section is TRUE rev1OK is set to 1 and rev2OK is set to 0. This works the
same for the subsequent sections (rev2OK = 1 and rev3OK = 0, rev3OK=1 and
rev4OK = 0).
In the first section the conditional formatting is 'rev1OK = 1 do not allow
users to insert or delete this control. In the second section the conditional
formatting is 'rev2OK not= 0 do not allow users to insert or delete this
control. The subsequent section has similar conditional formatting.
When I first set this up it worked as I expected.
BUT...when I reboot my computer and try to use the form these sections do
not behave properly...some sections open when they shouldn't others won't
open at all.
Here is what I found, the conditional formatting in the first section is
"rev4OK = 2", the second section "rev4OK = 1", the third "rev5OK = 2", forth
"rev5OK = 1" and fifth "rev1OK = 1"
This only happens after a reboot. If I just close and reopen the form it
does not change. PLEASE HELP! How do I prevent this from happening?