Re: Help needed on some code.
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Fri, 29 Feb 2008 07:28:20 -0500
Are you try to set End_Date to Null? If so, the statement is
End_Date = Null
If that is not what you are attempting to do, then please post back with a
little more explanation.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"jfaz" <jfaz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:266BB4EC-B5D8-41CD-89C2-C0D2655D38E3@xxxxxxxxxxxxxxxx
I am new to coding and have had some success but am baffled by this.
I have a form that I wish to ensure that the end date is the same as or
after the start date. I have attached the following code but it fails at
the
point where I am trying to clear out the end date field of the data
entered.
I would be grateful if someone could point out to me where I am going
wrong.
Private Sub End_Date_BeforeUpdate(Cancel As Integer)
If (Me.[End_Date]) <= (Me.[Start Date]) Then
MsgBox "Your must input a date after or the same as your start date"
[End_Date] IsNull
End If
End Sub
Any help would be welcome. Thanks in anticipation.
.
- Prev by Date: Re: User Form Command Button
- Next by Date: Re: type conversion error
- Previous by thread: Re: Help needed on some code.
- Next by thread: Re: User Form Command Button
- Index(es):
