Adding an auto-updating date modified field in a db's table

[kdog18]

Hi<br><br>This question has stumped me all morning. For the database I'm editing, data entry is done via the table and not through a form. I was wondering whether there is a way to add a date modified field into the table so every time a record is changed, the date modified field is changed to the current date without user intervention.<br>Thanks

 

[kathryn]

Hi,<br><br>The only thing you can set up is the default for the initial data entry, by using a field with DataType of Date/Time, and a default value of Now().<br><br>To change a field value in response to the change in another field is exactly what events, and coding in response to events, are for.&nbsp;&nbsp;You cannot attach code to a table, only to a form. <br><br>Could you create a form that LOOKS like a table, if that's what your users want?&nbsp;&nbsp;Then you could code away like a madman, or madwoman, as the case may be.<br><br>Kathryn

 

[kdog18]

Thanks, I'll do that.<br><br>Eric