D
deb
I am using Allan Browne's calendar and it works great!!
I have a form with ProjStart and ProjEnd, both are date fields using the
calendar.
I need to make sure the ProjEnd is not before ProjStart.
I tried...
Private Sub ProjStart_AfterUpdate()
If Me.ProjStart> Me.ProjEnd Then
MsgBox "ProjEnd cannot be before ProjStart"
Me.ProjStart.Undo
End If
End Sub
But it only works if the date is typed in, and not when using the calendar
control.
The calendar is triggered by the OnClick event using,
=CalendarFor([ProjStart],"Set Project Start date")
Please help,
I have a form with ProjStart and ProjEnd, both are date fields using the
calendar.
I need to make sure the ProjEnd is not before ProjStart.
I tried...
Private Sub ProjStart_AfterUpdate()
If Me.ProjStart> Me.ProjEnd Then
MsgBox "ProjEnd cannot be before ProjStart"
Me.ProjStart.Undo
End If
End Sub
But it only works if the date is typed in, and not when using the calendar
control.
The calendar is triggered by the OnClick event using,
=CalendarFor([ProjStart],"Set Project Start date")
Please help,