Automatically Update a Date Field

[SMatthews]

Is there any way to automatically update a field with todays date if another field has been changed? If yes, will it only work in a form, or will it work if you are updating info in a query and/or a table? Thanks in advance.

 

[Pat Hartman]

Access does not support triggers as do most other RDBMS'. Therefore the only way to do this is with code placed in the BeforeUpdate event of a form. This code would of course not be executed if you updated the table directly or through an action query.