Probably an Easy One!!! Please Help.

A

A. Smart

I have a list of fields with simple yes/no functions. I would like one more
yes/no field that would select all the other functions (i.e. ALL).
Any help would be very welcome.
Cheers
 
G

Graham R Seach

With the exception of the chkSelectAll, add the following code to the Click
event of every checkbox:
If (Me!chkCheckbox1 = True) Then Me!chkSelectAll = False

'Change "Me!chkCheckbox1" to the name of the relevent checkbox. Change
"Me!chkSelectAll" to the name of the checkbox that selects all the others.

In the chkSelectAll's Click event, add the following code:
If (Me!chkSelectAll = True) Then
With Me
!chkCheckBox1 = False
!chkCheckbox2 = False
' - - - -
!chkCheckbox10 = False
End With
End If

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
A

A. Smart

Excellent Graham my friend down under!
If I'm being pedantic:

In the chkSelectAll's Click event, add the following code:
If (Me!chkSelectAll = True) Then
With Me
!chkCheckBox1 = False (Should be true)
!chkCheckbox2 = False (Should be true)

Good Luck with the CRICKET!!!

Thanx again!
 
Top