Auto Update date when another field is changed (1 Viewer)

jamphan

Registered User.
Local time
Today, 04:48
Joined
Dec 28, 2004
Messages
143
I have 2 fields on a form. One is the Account Status which is a drop down list box and the other is Date Status Updated. I would like for the Date Status Updated field to automatically update to the current date when a selection is chosen or changed in the Account Status field. Is this possible? Thanks!
 

trucktime

Registered User.
Local time
Today, 05:48
Joined
Oct 24, 2004
Messages
556
Date

In the After Update Event of the list box you can put this code:

Me.Date Status Updated = Date()

It is a good policy not to use spaces in field names, it may cause
problems at some point.
 
Last edited:

WayneRyan

AWF VIP
Local time
Today, 11:48
Joined
Nov 19, 2002
Messages
7,122
jamphan,

TruckTime is right ... darned spaces!

Me.[Date Status Updated] = Date()

Wayne
 

Users who are viewing this thread

Top Bottom