set multiple check boxes with one click

[tinkicker]

I have a form which reads a single table with multiple sets of check boxes. The check boxes are logically nested and I would like to have the major category box checked automatically anytime a lower level box is checked. I searched several ways and didn't find anything exactly on point. I am using 2003 (I know ancient history) and am very much a novice at VBA.

I tried the following in the On Click event of each of the subcategory check boxes:

IF Me.Rater_atc_error = True Or Me.Rater_atc_comm = True Or Me.Rater_atc_challenge = True Or Me.Rater_atc_PDC = True Then
Me.Rater_atc_complication.Value = True

When I click on the sub category box it checks but the Then portion doesn't set the major category check box. I tried using -1 instead of True and I tried in both the On Click and On Update events and i looked to see if the underlying table was updated but the form just didn't show the check (it was still false). The allow edit property is yes on the form.

Any idea what I'm doing wrong?

Thanks for the help!

 

[jal]

Maybe you're using the wrong event. You said On_Click? Set a breakpoint in the code to make sure that event is firing. If not, try the AfterUpdate event.

 

[John Big Booty]

There was some discussion of this topic in the thread here

 

[tinkicker]

There was some discussion of this topic in the thread here

I had read that one before I posted and it wasn't helping. However, I finally figured out the problem..... basically, I'm an idiot

I was working in Access 2007 (in compatible mode) and had the 'certain content' disabled and had hidden the warning ribbon. Cleared that up and everything now works fine!

Thanks for the help.