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

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

Guest

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
 
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
 
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
 
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"
 
Thank you al kamp your idea works perfect
Al Camp said:
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
Click to expand...
 
Back
Top