Groundrush
Registered User.
- Local time
- Today, 22:26
- Joined
- Apr 14, 2002
- Messages
- 1,376
Hi All,
I'm trying to prevent users from entering dates prior to the 16-03-09 & any dates in the future
I created this code to prevent users from entering future dates & put it in the before update of the date field
I cant work out how to prevent users from entering dates prior to the 16/03/2009
I'm sure there is a better way of doing this
Any suggestions
Any help would be much appreciated
Thanks
I'm trying to prevent users from entering dates prior to the 16-03-09 & any dates in the future
I created this code to prevent users from entering future dates & put it in the before update of the date field
Code:
If Me.txtTMDate >= Date Then
MsgBox "This date is in the future, please check your records & try again"
Me.txtTMDate = ""
End If
I cant work out how to prevent users from entering dates prior to the 16/03/2009
I'm sure there is a better way of doing this
Any suggestions
Any help would be much appreciated
Thanks