reset an event for each new record

[mkelly]

I have an event procedure on my main form. However, once it is clicked on the first record it does not reset for each record after that. the code is:

Private Sub Outbound_Mail_Click()
If [outbound mail] = -1 Then
[Form_Outbound Mail].Visible = True
Else
[Form_Outbound Mail].Visible = False
End If
End Sub

How can I get it to reset for new records?
Any help appriciated.

Thanks

 

[Fornatian]

put Outbound_Mail_Click in the Current event, that way every time the record changes the click event will occur making the visibility change accordingly.