Button Command to Uncheck all Checkboxes

[banks13cu]

I have a form that is linked to a query/table. I need a command that when a button is pressed on the form it will automatically uncheck all the checked checkboxes in a particular query/table column. I need this to save the table too. If you have any ideas or suggestions please let me know.

 

[TheAceMan1]

How are ya banks13cu . . . . .

Have you tried an [blue]Update Query![/blue]

See Ya! . . . . . .

 

[PHV]

Why not simply an Update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WallT]

I have a form where I use the following to clear my check boxes on a form with a Option Group. Maybe this can point you in the right direction. I set the tag for the option group to "Clear" Then use the following code behind a command button:

Private Sub cmd_ClearAll_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Clear" Then ctl = False Or Null
Next ctl
End Sub

 

[RoyVidar]

Another approach than query, is using the form recordset thread702-698417

Roy-Vidar