how to tick all checkboxes

[darwin]

hi



I have a question, I have a checkbox in the formheader, and what I want is when I make a selection in the checkbox in the formheader, then all the checkboxes
in the detail sections must be selected for the search result:

I have tried this in vba but only the first checkbox in the detail section is selected, see picture below here, but
I want all the checkboxes to be selected for the search result.

My vba code:

Private Sub felt103_AfterUpdate()


Me.Ma1X = Me.felt103


End Sub

[June7]

Options:

1. SQL UPDATE action that sets value for all records in table that meet specific criteria

2. looping code that moves to each record in the form's RecordSource and sets the field

[darwin]

thanks june7

do you have any examples of looping code in the form's RecordSource ?

[orange]

Looping through a recordset example

via Google.

[June7]

Can use RecordsetClone.

With Me.RecordsetClone
.MoveFirst
While Not .EOF
.Edit
!Ma1X = Me.felt103
.Update
.MoveNext
Wend
End With