I have a small alert form. I have the following procedure on timer (750). How can I get the count NOT to blink when the count is zero. The blink occurs regardless of the count (blinks when the requery is run). Thanks
DoCmd.Requery
If Me.CountQueue >= 1 Then
With Me.Label241
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
End With
Else
End If
DoCmd.Requery
If Me.CountQueue >= 1 Then
With Me.Label241
.ForeColor = (IIf(.ForeColor = vbRed, vbBlack, vbRed))
End With
Else
End If