Referencing a subform datasheet object from a form

[Dugantrain]

What I have is a main form with a subform datasheet. When the user clicks an Option button on the main form, I need for every record in a certain field on the datasheet to go to "0". So far, my code is:

Private Sub Option33_Click()
If [Forms]![frmsparesite].[Form]![Option33] = True Then
[Forms]![frmsparesite]![SubformSpareSiteParts].[Form]![Need] = 0
End If
End Sub

This puts a zero in the top field only; I need it to place a zero in every field. How may I accomplish this?

 

[pono1]

DuganTrain,

Experimenting with code like the following to update the table behind the subform will hopefully move you closer to a solution.

If [Forms]![frmsparesite].[Form]![Option33] = True Then
  
      Dim strSQL As String
      strSQL = "UPDATE TblBehindSubForm SET TblBehindSubform.need = 0 " & _
        "WHERE TblBehindSubForm.LinkField=[forms]![FrmMainForm].[LinkField];"

       DoCmd.SetWarnings False
            DoCmd.RunSQL strSQL
       DoCmd.SetWarnings True
        
        Me.Recalc
End If

Regards,
Tim