date field that registers when a register has been modified

's Computer Specifications

how can I create a field to register date and time of any register at the
moment it is modified

's Computer Specifications

You can only do this if you're doing all of your updates through Forms. Put
logic in the form's BeforeUpdate event to set the LastUpdateDTM field to
Now().

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"OGU" <(E-Mail Removed)> wrote in message
news:7EF707FD-3B4B-4B46-9200-(E-Mail Removed)...
> how can I create a field to register date and time of any register at the
> moment it is modified

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
modified date field	ljg08	Microsoft Access Database Table Design	2	20th Jun 2008 12:20 PM
Date last modified for a field	jhicsupt	Microsoft Access Forms	3	3rd Mar 2008 02:07 PM
Modified Date Field	Jason	Microsoft Access Forms	3	3rd May 2005 03:14 PM
'Date Modified' field	Wayne G. Dengel	Microsoft Access Getting Started	6	30th Sep 2003 11:26 PM
Name of Field that registers date and time of last change?	Kristian	Microsoft Outlook Form Programming	4	10th Jul 2003 02:20 PM