detect checkbox click

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

i have a form with a bunch of yes/no checkbox bound fields.
how can i right one method that is fired whenever any checkbox is clicked.
let's say i have 10 checkboxes that if any one of them is clicked one main
checkbox is clicked for that row.
so if any one of the 10 conditions is found to be true the true indicator is
checked for the row.

TIA,
mcnewsxp
 
mcnewsxp said:
i have a form with a bunch of yes/no checkbox bound fields.
how can i right one method that is fired whenever any checkbox is clicked.
let's say i have 10 checkboxes that if any one of them is clicked one main
checkbox is clicked for that row.
so if any one of the 10 conditions is found to be true the true indicator is
checked for the row.
Click to expand...


Set the row check box's control source expression to this
kind of expression:

=chk1 Or chr2 Or chk3 Or . . .
 
:
Set the row check box's control source expression to this
kind of expression:

=chk1 Or chr2 Or chk3 Or . . .
Click to expand...

the field is bound.
will it update the table this way?
 
mcnewsxp said:
the field is bound.
will it update the table this way?
Click to expand...


The answer is: No, it won't update the table.

The question is: Why is it bound? That would be a
violation of the rules of database normalization.

If it really is necessary to bind the redundant value, then
use VBA code in the AfterUpdate event of all ten check
boxes:
maintextbox = chk1 Or chr2 Or chk3 Or . . .
 
i have a form with a bunch of yes/no checkbox bound fields.
The answer is: No, it won't update the table.

The question is: Why is it bound? That would be a
violation of the rules of database normalization.
Click to expand...

omegawd!
i violated the rule.
isn't it a violation of the rules of good manners to assume someone isn't
aware of the rules.
sometimes we do not have the luxuery of or even the need for the dang rules.
good manners dictates you answer the question put forth or never mind.
If it really is necessary to bind the redundant value, then
use VBA code in the AfterUpdate event of all ten check
boxes:
maintextbox = chk1 Or chr2 Or chk3 Or . . .
Click to expand...

that is basically what i did and was trying to avoid.

thanks,
mcnewsxp
[just someone who's been programming for over 15 years]
 
Back
Top