Recordset edit values in fields of each record

[Ruegen]

I have

                                        rs.Edit
                                        If rs!ConfirmationSent2nd = False Then
                                        rs!ConfirmationSent2nd = True
                                        End If
                                        rs!ConfirmCount2 = rs!ConfirmCount2 + 1
                                        rs!ConfirmDate2 = Date
                                        rs!ConfirmTO2 = Nz(TourOrganiserID, "")
                                        rs.Update

It updates the bool confirmationsent2nd fine and confirmdate2 but not the other two... can't figure out why.

confirmCount2 is a number field
so is confirmTO2

[June7]

Don't use "" in the Nz(), use 0 or Null.

[Ruegen]

Don't use "" in the Nz(), use 0 or Null.

I changed it but I still get a loop break.

If I quote block out the whole rs.edit -> rs.update then the loop works again.

[Ruegen]

rs.edit
rs.ConfirmDate2 = Date
rs.update

This part works fine

woops just figured it out sorry June many apologies something very very simple that I forgot to do.