Recent content by srferson

*sigh* I think I was being an idiot. Well, not an idiot, but I was looking at something in the wrong way. I'd explain, but it's too confusing to explain my brain. Especially my Friday brain. Thank you for your help. You helped my brain wake up and kick itself. :rolleyes:

If I am understanding you correctly, you're saying that the control names need to go there. But there are no control names. Blue and Red do not have controls on the form. They are fields in the underlying table. I realize I could put controls on the form for Blue and Red, but I'd prefer not to...

Thanks for the fast response! Unfortunately, this doesn't work. It's actually the way I tried it at first too. But I just tried it again and I call it like this: Call CheckUncheck(chkBlue, Blue, Red) And I get a type mismatch. Keep in mind that Blue and Red are fields in the table the form...

Behind a form I have the same code over and over for a bunch of checkboxes: If chkBlue = -1 Then Blue = 1 Red = 0 End If If chkBlue is the checkbox on the form for the field Blue in my table and there is also another field named Red in my table, when Blue's checkbox is checked, Blue is set...