Getting Date Only

C

CyndyG

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.
 
R

Rick B

AFTER update fires AFTER you have updated (saved) the record.

Do it in the BEFORE update evnet, and it should be,,,

dteDatedClosed = Date()
 
P

Pat Hartman

Are you sure the value of the field is "Closed"? If the status field is a
combo, the actual value will probably be numeric.
 
D

Dirk Goldgar

CyndyG said:
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.
Click to expand...

This is in the AfterUpdate event for the control named
"strRequestStatus"?

Do you have a control or public variable named "Date"? That could be
confusing Access and VBA.

Have you set a breakpoint and stepped through the code to see that it
executes the statements you think it does? If it fails the test in the
If statement, check the value of strRequestStatus to make sure that it's
really what you think it is.
 
Top