Clearing all Check Boxes

J

John Vinson

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Word OLE to check spelling in text box 1
How to clear areas of a locked Doc after each use-- 0
How to automate update on weekly reports spreadsheet 0
Populate a table based on check box status 2
VBA: Programmatically clear a one-key shortcut bound to a document 2
OLE Word spelling 0
Clear button for template 1

Top