"Check all" button checkboxes in MS Access

[chengsi]

Hi,

I have a "continuous" subform which is linked to a table which has a checkbox field. I would like to create a Check All/Uncheck All checkbox control that both checks and disables the checkboxes in the subform.

At the moment I can disable/enable all textboxes, however my coding only checks/unchecks the FIRST checkbox in the subform, and ignores the other checkboxes in the list. My current VBA code is:

Private Sub Check5_AfterUpdate()
If Check5 = True Then
Aust_Ent_Sum = True
Aust_Ent_Sum.Enabled = False
Else
Aust_Ent_Sum = False
Aust_Ent_Sum.Enabled = True
End If
End Sub

"Aust_Ent_Sum" is the name of the checkboxes i want to check. Any help in checking/unchecking ALL the checkboxes would be appreciated!

Thanks, Siwei

[ChaseCox]

I answered a similair question here,

The Scripts

[chengsi]

ChaseCox,

Appreciate your reply, however my issue is that the number of checkboxes are not fixed as they are determined by the number of entries in the table (which is dynamic). Also, the checkboxes do not have individual names as they are essentially one control (i.e. Aust_Ent_Sum) being used to represent the entire field in a continuous form.

I had been thinking maybe some sort of loop is required in VBA, but not sure. Anyone have any suggestions?

Thanks, Siwei

[ChaseCox]

ChaseCox,

Appreciate your reply, however my issue is that the number of checkboxes are not fixed as they are determined by the number of entries in the table (which is dynamic). Also, the checkboxes do not have individual names as they are essentially one control (i.e. Aust_Ent_Sum) being used to represent the entire field in a continuous form.

I had been thinking maybe some sort of loop is required in VBA, but not sure. Anyone have any suggestions?

Thanks, Siwei

Are you actually creating them as you go along? if so how is that done?

[mrowe]

Try looking at the following post:
http://www.thescripts.com/forum/showthread.php?p=2449139#post2449139

I believe you are having the exact same problem that someone else helped me solved.
Mark