I have the following VBA in a form:
Private Sub Text80_AfterUpdate()
If Me.Text80 > 60 Then
MsgBox "Check Year in Payroll Date.", vbOKOnly
ElseIf Me.Text80 < -60 Then
MsgBox "Check Year in Payroll Date.", vbOKOnly
End If
End Sub
This does not seem to work as when the value is either greater than 60 or less than -60 it doesn't give a message.
Any idea why this would not work?
Thank you!
Private Sub Text80_AfterUpdate()
If Me.Text80 > 60 Then
MsgBox "Check Year in Payroll Date.", vbOKOnly
ElseIf Me.Text80 < -60 Then
MsgBox "Check Year in Payroll Date.", vbOKOnly
End If
End Sub
This does not seem to work as when the value is either greater than 60 or less than -60 it doesn't give a message.
Any idea why this would not work?
Thank you!