Can someone help me with this If condition?
If[Forms]![fInvChkCo]![date]=Month(Now())
what i would like is to trigger an action if the month stated in [date] is the current month.
I'm using this in a macro that will open a form if the date is in the current month but i don't seem to be able to get this to work?
Can anyone suggest what i'm missing here?
thanks in advance.