I have a loop where if rs!ConfirmationSent4th <> true then send an email
and the end of the email with I have added
Code:
If rs!ConfirmationSent4th = 0 Then
rs!ConfirmationSent4th.Edit
rs!ConfirmationSent4th = -1
rs!ConfirmationSent4th.Update
End If
I was hoping to not only do the task set out but change each me.confirmationsent4th to true using the rs
It breaks and doesn't move to the next task or update anything.
Any advice?
Sorry guys
used
If rs!ConfirmationSent4th = 0 Then
rs.Edit
rs!ConfirmationSent4th.Value = -1
rs.Update
End If