Record addition

[Guest_imported]

How would I populate a date field with today's date after a specific field has been changed to a finish status.

I have a record such as:

ID Status CompleteDate
2 In Work

When Status is changed to Completed I want it to automatically populate the CompleteDate field with todays date ( the date Status was changed to 'Completed') such as:

ID Status CompleteDate
2 Completed 4/4/2002

Is there a trigger or something in Access 2000 that will do this for me??

 

[andrep]

You could create an event procedure on the lost focus of the status field to have it write todays date within the completed date!


ie:

dim st as string
dim cd as date

st = me!status

if st = "completed" then
cd= now()
me!CompleteDate = cd
end if
end sub

Hth
André

 

[WildHare]

On your AfterUpdate event for the first guy, add this line:

Me!CompleteDate = Switch(Me!Status="Completed", Date(), TRUE, Null )

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm