Hello! I have a continuous form as a subform that has a junction table as control source. On the parent form that is linked to this junction table, I want to prevent orphan records with the code provided by Richard. It works fine for multiple other forms in my Db but this one is a tricky one. Ive tried this code but doesn't seem to delete anything because there are records in the "child" table. Any ideas?

Private Sub Form_Unload(Cancel As Integer)
    If IsNull(EffectifSR) And Not IsNull(EffectifID) Then
        If Not IsNull(Form.SubF_OF_F!ID) Then
            Dim rs As Recordset
            Set rs = Me.SubF_OF_F.Form.RecordsetClone
            rs.MoveFirst
            Do Until rs.EOF
                DoCmd.SetWarnings False
                DoCmd.RunSQL "DELETE FROM Jonction_OF_T WHERE ID=" & rs!ID
                DoCmd.SetWarnings True
            
                rs.MoveNext
            Loop

            Set rs = Nothing
        End If
        DoCmd.SetWarnings False
        DoCmd.RunSQL "DELETE FROM EffectifSR_T WHERE EffectifID=" & EffectifID
        DoCmd.SetWarnings True
    End If
End Sub