K
knelsen
I have a form linked to an Access database. It contains several sections
that are supposed to be hidden unless corresponding checkboxes are checked.
When I first set up the conditional formatting, the sections remained hidden
even after a box was checked, and I guessed that this was because the value
in the database doesn’t change until the form is submitted. To get around
this I added a separate checkbox to the form, and used a rule to change the
value of the checkbox in the database to match. This worked for input, but
now I have a problem when I query. The checkboxes all come up blank, and
users can’t see which sections were filled out. Any ideas on how to fix this?
that are supposed to be hidden unless corresponding checkboxes are checked.
When I first set up the conditional formatting, the sections remained hidden
even after a box was checked, and I guessed that this was because the value
in the database doesn’t change until the form is submitted. To get around
this I added a separate checkbox to the form, and used a rule to change the
value of the checkbox in the database to match. This worked for input, but
now I have a problem when I query. The checkboxes all come up blank, and
users can’t see which sections were filled out. Any ideas on how to fix this?