Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-28-2004, 09:03 AM   #1
jamphan
Registered User
 
Join Date: Dec 2004
Posts: 143
Thanks: 0
Thanked 0 Times in 0 Posts
jamphan is an unknown quantity at this point
Auto Update date when another field is changed

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!

jamphan is offline   Reply With Quote
Old 12-28-2004, 10:19 AM   #2
trucktime
Registered User
 
Join Date: Oct 2004
Location: Arizona
Posts: 556
Thanks: 0
Thanked 2 Times in 1 Post
trucktime is on a distinguished road
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.
__________________
Trucktime

Last edited by trucktime; 12-28-2004 at 11:20 AM.
trucktime is offline   Reply With Quote
Old 12-28-2004, 11:43 AM   #3
WayneRyan
AWF VIP
 
Join Date: Nov 2002
Location: Camarillo, CA
Posts: 7,091
Thanks: 6
Thanked 62 Times in 58 Posts
WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough
jamphan,

TruckTime is right ... darned spaces!

Me.[Date Status Updated] = Date()

Wayne

WayneRyan is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 06:43 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World