Conditional Formatting on Continuous Subform (VBA)

[Guest]

I have a subform with 7 check boxes, and if none of them are checked, I'd
like the background color to change. The code I have now is:

Private Sub Form_Load()
If (Check1 + Check2 + Check3 + Check4 + Check5 + Check6 + Check7 = 0) Then
Detail.BackColor = 8454143
Else
Detail.BackColor = -2147483633
End If
End Sub

The problem is, this is applying to all instances of the continuous subform
together, not evaluating each instance on its own. How can I get it to do
that?

Thanks,
Tim

 

[Van T. Dinh]

You are *not* using ConditionalFormatting with your current code in the Load
Event.

See the sample database from stephen Lebans:

http://www.lebans.com/conditionalformatting.htm

 

[Guest]

Thanks, Van. That database was very helpful!

Tim