[AccessD] error in code

for i  = 1 To 9
If "chb" & i & "c31") = True Then

Your condition is never going to equal true -- but rather a cancatenated
string. Although, I think the code's missing soemthing -- you've got a )
that doesn't make sense in its position, but I suspect that's just a typo
and probably isn't your actual error is it?

Susan H.