
Originally Posted by
UT227
I got the same error. It doesn't like the IF statement. Didn't I make the S1 and S2 a string?
It is not the IF() function, it is the MONTH() function. The MONTH() function requires a DATE!
(Syntax -> Month(date))
Code:
If Month(S1) <> Me.cboMonth Then
You are passing S1 to the month function - where S1 is declared as a STRING NOT a DATE! (as Minty stated)
Maybe you could post an example of your calendar and code........
HTH
-----
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)