dbTalk Databases Forums  

Need to create date update field in a form

comp.database.ms-access comp.database.ms-access


Discuss Need to create date update field in a form in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sjboyd81
 
Posts: n/a

Default Need to create date update field in a form - 10-30-2003 , 11:08 AM






I have a date field in a form that I'm using that I want to
automatically update to the current date anytime I change any
information in that record.
Therefore, if the original date I worked on a customer record was
6/20/03 and I changed some information on 10/30/03, I would want it to
change the date to 10/30/03. This way, the next time I look at the
record I will be able to know when I last changed information and
therefore how recent and accurate the record information is. Does
anyone know how to do this? Someone told me a long time ago, but I
have since lost the instructions and can't remember how. Can anyone
help?

Reply With Quote
  #2  
Old   
janthony
 
Posts: n/a

Default Re: Need to create date update field in a form - 10-31-2003 , 02:23 PM






One way is to simply add a line of code to the "After Update" event of
the form or one of the fields.

The line would simply be...

Me.txtDatefield = Date()

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.