capture date/time when data modified

[joyaccess1]

Hi,
I have a column called "lastModifiedDate" in a table, i would need the form to automatically capture the date and time when any of the data elements are modified in the form, also i don't want the user to modify this column in the form, is this possible ?. if yes, then how can i achieve this ?

Thanks for any help
Joy

 

[boblarson]

Set the text box in the form to Enable = False and Locked = True then nobody can edit it. In the Form's Before Update event (after any code that might cancel the update), put

Me.LastModifiedDate = Now

 

[joyaccess1]

Thanks bob

 

[boblarson]

Glad we could help - and Welcome to Access World Forums, by the way.