PC Review

Thread Tools Rate Thread

Uncheck all checkboxes on update

New Member
Join Date: Feb 2012
Posts: 5
      2nd Feb 2012
Hi there,
I have a form with about 14 checkboxes (but they are purely labels, not associated with anything)...When a user clicks on one, it brings up another form for additional information and stored in another table.

When the user is done, they click Submit, and I need ALL checkboxes to go back to False. I have seen users suggesting an update query but my checkboxes are LABELS so I can't put a table in the query.

I was thinking of putting some VBA code in the OnClick event of "Submit"...Something like
For i= # to #
me.checkbox(i) = false
Next i

However that doesn't work. Any suggestions?
Reply With Quote
New Member
Join Date: Feb 2012
Posts: 5
      2nd Feb 2012
Well no one answered but I was able to code a solution for anyone interested.
In the Click() event for my Submit button I put the following code after my "New record" command

For Each Control In Form.Controls 'Clear all form checkboxes on Submit
If Control.ControlType = acCheckBox Then
Control.value = False
End If
Next Control

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check/uncheck checkboxes from javascript Dilip Microsoft ASP .NET 1 12th Jul 2007 08:59 PM
Uncheck all checkboxes - update query question =?Utf-8?B?WGFuZQ==?= Microsoft Access 3 18th May 2007 02:35 AM
Re: uncheck checkboxes from a form Bob Phillips Microsoft Excel Programming 1 8th Jan 2007 02:08 AM
How do I check/uncheck ten or odd Checkboxes by click on one check =?Utf-8?B?S2VuIFZv?= Microsoft Excel Misc 5 5th Jan 2006 12:10 AM
Check uncheck all checkboxes =?Utf-8?B?VkI=?= Microsoft Access 3 6th Nov 2005 05:59 PM




All times are GMT +1. The time now is 01:22 AM.