If Statement Help

sandylt

Registered User.
Local time
Today, 05:06
Joined
Mar 11, 2004
Messages
36
#1 Need to find a way to make this code work. Can anyone help??

If Me.CurrentDue2 Between FirstofMonth And LastofMonth
Me.CurrentDue2.Visible = True
Else
Me.CurrentDue2.Visible = False
End If

It keeps highlighting BETWEEN I guess this parameter is wrong does anyone know how to do this? If CurrentDue2 is between First of Month and LastOfMonth then it is visible.

#2 I have Five fields that have a numerical value and I have a field that totals those boxes together. If some boxes are invisible due to code is there a way I can total just the visible boxes only?

Any help is welcome, thanks!?!?!
 
If Me.CurrentDue2 >= FirstofMonth And Me.CurrentDue2 <= LastofMonth

???
ken
 

Users who are viewing this thread

Back
Top Bottom