Re: Getting Date Only
- From: "Pat Hartman" <patsky@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 16:19:28 -0400
Are you sure the value of the field is "Closed"? If the status field is a
combo, the actual value will probably be numeric.
"CyndyG" <CyndyG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:111DD283-05BF-44A5-9562-0C7DC01766CB@xxxxxxxxxxxxxxxx
> I can not get the date to appear in a field automatically after a certain
> event occurs. Here is the code:
>
> AfterUpdate for strRequestStatus Field
> If Me.strRequestStatus = "Closed" Then
> dteDatedClosed = Date
> End If
>
> I have tried on lost focus,
> I have tried using Date(), have tried setiing the date to short date,or
> formatting to mm/dd/yyyy.
> At one point I clicked in the field the date showed up,but went away when
I
> saved the form.
>
> This is the same code I used in another database using Now() instead with
no
> problem.
>
>
>
>
>
.
- References:
- Getting Date Only
- From: CyndyG
- Getting Date Only
- Prev by Date: Re: How to determine source of opened form
- Next by Date: Re: Where Condition
- Previous by thread: Re: Getting Date Only
- Next by thread: Re: Getting Date Only
- Index(es):
Relevant Pages
|