how do i set a check all check box or commend in access

[Monroe]

i had like to make a check to select all records it should be check or
unchecked like on yahoo mail
or a comend botton "check all" and "clear all" like on the camara downloed
wizerd on windows xp

 

[Al Camp]

Monroe,
Lets say you had 3 "bound" checkboxes already. (ex. chkA, chkB, chkC) Add a 4th
"unbound" checkbox to the form. (ex. chkAll)
Using the AfterUpadte event of chkAll...
If chkAll = True Then
chkA = True
chkB = True
chkC = True
Else
chkA = False
chkB = False
chkC = False
End If

 

[Monroe]

thank you al kamp please anser again!
but what i try to do is a little bit difrent i had tryed to make a list of
costumers then i create a check box to whom i want to send a statement but i
want to be able to select all at once or deselect all at once

 

[Al Camp]

Monroe,
Create an Update query against the customer table that sets the value of checkbox on
each record to True.
Create another Update query that does the opposite.
One button to "Check All" and another to "Clear All"

 

[Monroe]

Thank you al kamp your idea works perfect

Monroe,
Create an Update query against the customer table that sets the value of checkbox on
each record to True.
Create another Update query that does the opposite.
One button to "Check All" and another to "Clear All"
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions