J John Vinson Jun 4, 2004 #2 how can i clear all check boxes once an event occurs ? thx Click to expand... Depends; where are the checkboxes? Are they Yes/No fields in a Table? If so, an Update query updating the field to False would work. Or are they checkbox controls on a Form? If so, you'll need to clear them one by one in code: Me!chkBox1 = False Me!chkBox2 = False or loop through the form's Controls collection.
how can i clear all check boxes once an event occurs ? thx Click to expand... Depends; where are the checkboxes? Are they Yes/No fields in a Table? If so, an Update query updating the field to False would work. Or are they checkbox controls on a Form? If so, you'll need to clear them one by one in code: Me!chkBox1 = False Me!chkBox2 = False or loop through the form's Controls collection.
B Bandit Jun 4, 2004 #3 Hi, After the event set all the checkbox values to -1 and requery. me.checkbox1.value=-1 me.checkbox2.value=-2 me.requery Have a good day, Bandit
Hi, After the event set all the checkbox values to -1 and requery. me.checkbox1.value=-1 me.checkbox2.value=-2 me.requery Have a good day, Bandit
J John Vinson Jun 4, 2004 #4 Hi, After the event set all the checkbox values to -1 and requery. me.checkbox1.value=-1 me.checkbox2.value=-2 me.requery Click to expand... Actually, -1 is True/checked/yes; 0 is False/unchecked/no.
Hi, After the event set all the checkbox values to -1 and requery. me.checkbox1.value=-1 me.checkbox2.value=-2 me.requery Click to expand... Actually, -1 is True/checked/yes; 0 is False/unchecked/no.
