>I have a field that was once a required field. I eventually decided not to
>make it required (to make a long story short). This is what I would like to
[quoted text clipped - 10 lines]
>(or if it's already filled in), the user is then allowed to check the
>Completed checkbox.
Thanks Marshall,
That works, thanks. However, I now want to modify the code to place it in
the AfterUpdate event of a Date/Time field, instead of the checkbox field. I
would no longer use "True", correct? How would I write . . .
If Me.DateTimeEnded = ??? Then
Thanks!
> >I have a field that was once a required field. I eventually decided not to
> >make it required (to make a long story short). This is what I would like to
[quoted text clipped - 19 lines]
> End If
> End If
Marshall Barton - 04 May 2005 13:51 GMT
I think you now want to use:
If Not IsNull(Me.DateTimeEnded) Then
, , ,

Signature
Marsh
MVP [MS Access]
>That works, thanks. However, I now want to modify the code to place it in
>the AfterUpdate event of a Date/Time field, instead of the checkbox field. I
[quoted text clipped - 25 lines]
>> End If
>> End If