Runtime Error message 94
Can anyone help with the following?
I am trying to use the MONTH function within the following procedure but I get an 'Invalid use of Null' error when [StartDate] is blank!
Private Sub StartDate_AfterUpdate()
Dim aMonth As Integer
aMonth = Month([StartDate])
If aMonth = 0 Then WOW = WOW
If aMonth = 1 Or aMonth = 2 Then WOW = 0.6
End Sub
Can anyone help with the following?
I am trying to use the MONTH function within the following procedure but I get an 'Invalid use of Null' error when [StartDate] is blank!
Private Sub StartDate_AfterUpdate()
Dim aMonth As Integer
aMonth = Month([StartDate])
If aMonth = 0 Then WOW = WOW
If aMonth = 1 Or aMonth = 2 Then WOW = 0.6
End Sub
Last edited: