Probably an Easy One!!! Please Help.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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!
 
Back
Top