detect checkbox click

[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

 

[Marshall Barton]

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.

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

=chk1 Or chr2 Or chk3 Or . . .

 

[mcnewsxp]

:

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

=chk1 Or chr2 Or chk3 Or . . .

the field is bound.
will it update the table this way?

 

[mcnewsxp]

i have a form with a bunch of yes/no checkbox bound fields.

the field is bound.
will it update the table this way?

the answer is no.

 

[Marshall Barton]

the field is bound.
will it update the table this way?

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 . . .

 

[mcnewsxp]

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.

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 . . .

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

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