A
alex
Using Access '03...
With the help of this group, I have a form with a number of checkboxes
that hide/unhide columns on a subform.
Arvin just guided me to store the value of these checkboxes in a table
(which I've done). This appears to be working well, but the code
behind my checkboxes is not reevaluating upon a record change.
Let's see if I can't confuse anyone...
A user opens the form and sees one record, a subform (in datasheet
view), and about 10 checkboxes that will hide/unhide a number of
columns in the subform. As the user cycles through the records, the
value of each individual checkbox changes (again, the values are
stored in a table associated with each record).
The problem, however, is that my checkbox code is not firing as the
records cycle. When the user cycles through each record, I need the
form to look and see what value is contained in each checkbox and show/
not show the appropriate column...everytime the form loads or record
changes. I think I've done something similar in the past...I'm
checking some old code to see. Any help would be appreciated.
alex
With the help of this group, I have a form with a number of checkboxes
that hide/unhide columns on a subform.
Arvin just guided me to store the value of these checkboxes in a table
(which I've done). This appears to be working well, but the code
behind my checkboxes is not reevaluating upon a record change.
Let's see if I can't confuse anyone...
A user opens the form and sees one record, a subform (in datasheet
view), and about 10 checkboxes that will hide/unhide a number of
columns in the subform. As the user cycles through the records, the
value of each individual checkbox changes (again, the values are
stored in a table associated with each record).
The problem, however, is that my checkbox code is not firing as the
records cycle. When the user cycles through each record, I need the
form to look and see what value is contained in each checkbox and show/
not show the appropriate column...everytime the form loads or record
changes. I think I've done something similar in the past...I'm
checking some old code to see. Any help would be appreciated.
alex