Delete all checkbox (1 Viewer)

[roccoau]

Hi
I have a continuous form and one of the feilds is a checkbox.
What I would like to do is have a command button which when I click it all the checkbox's which have a check in them to be deleted.
Can anyone please help me with how I could do this.

Tks Roc

 

[roccoau]

Found my answer
http://www.access-programmers.co.uk/forums/showthread.php?t=85794&highlight=clear+checkbox

Should have searched a bit better the first time.

 

[missinglinq]

A simpler solution would be:

Dim ctrl As Control

For Each ctrl In Me.Controls
    If TypeOf ctrl Is CheckBox Then
       ctrl.Value = False
    End If
Next

Depending on your needs you could put it behind a button or in some other event.

 

[roccoau]

A simpler solution would be:

Dim ctrl As Control

For Each ctrl In Me.Controls
    If TypeOf ctrl Is CheckBox Then
       ctrl.Value = False
    End If
Next

Depending on your needs you could put it behind a button or in some other event.

Thanks I will give it a go