Run Macro if =2

[Groundrush]

IMO

You have helped me more than I realised.

I didn't notice that you had put some code in the main form on Current

Private Sub Form_Current()
If Me.FirstLetterSent = False And Me.LookUpAlarms = 2 Then
MsgBox "This Property has had 2 False Alarms within the last 12 Months, please send out a First Action Letter."
End If

If Me.SecondLetterSent = False And Me.LookUpAlarms > 3 Then
MsgBox "This Property has had 4 or more False Alarms within the last 12 Months, please send out a Second Action Letter"
End If

End Sub

I have been sitting here trying to work out how to go about doing something similar and found your code.

thanks

I will test it properly now

cheers

 

[IMO]

I forgot to mention I'd added that

IMO