I have a form that is an Event form. The main form has the info about the Event, the sub form has the attendees. for each attendee I have a checkbox (HonoredGuest) if checked we pay for their meal. on the row I also have a checkbox (IsPaid). For the ones that the HonoredGuest is checked I would like to make the IsPaid not visible and visa versa. Here is the code I'm currently trying to use (I know there are many ways to do this);

Details

Private Sub HideIsPaid()
    
    Dim rs As DAO.Recordset

    Set rs = Me.RecordsetClone

    rs.MoveFirst
    Do While Not rs.EOF
        If rs!HonoredGuest.Value = -1 Then
            IsPaid.Visible = False
        Else
            IsPaid.Visible = True
        End If
        rs.MoveNext
    Loop

    rs.Close
    Set rs = Nothing
    
End Sub

I have tried first in the HonoredGuest AfterUpdate Event
     If honoredGuest then IsPaid.Visible = False
I did try something else but it's totally wiped from my brain lol

I'll attached two pics, seems when I have the last one checked all the IsPaid vanish.

Thanks