Multiple Bound Check Box 'Resets'

[PinkyP_23]

G'day guys,



I’ve got a bit of an issue and wondering if someone could help me.

I have to be able to build a report based on user selected records in a form. That’s all easy enough, however I’m having difficulty resetting all of the check boxes to their default ‘no’ (0).

What I’ve done is created a bound check box for each displayed record. When you click the reset button the following VBA runs;

Private Sub ResetButton_Click()
If ScheduleBuilder = -1 Then
'Reset back to default (0 = No)
ListBuilder = 0
End If
End Sub

However this only works on the last checked record or on each individual record if I put a button on them.


Is there a code which I can run on a button which will reset all of the record’s check boxes displayed in the form at once?

By way of background;
Form = SearchResultsForm
Button = ResetButton


Field check box is bound to = ListBuilder
Table = Database


Any help would be greatly appreciated!

Cheers,
Pinky

[June7]

Try:

Private Sub ResetButton_Click()
CurrentDb.Execute "UPDATE Database Set ListBuilder=False"
Me.Refresh
End Sub

[PinkyP_23]

Try:

Private Sub ResetButton_Click()
CurrentDb.Execute "UPDATE Database Set ListBuilder=False"
Me.Refresh
End Sub

Thank you June - you're a life saver.

I gave it a crack and it would only reset the last edited box, however after just popping a quick close and open, upon reopen all the boxes were back to default.

Thank you again June!

[June7]

Maybe instead: Me.Requery