#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 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!?!?!