Record Additions / Changes

[Bill Cormier]

How do I set it up so that whenever a record is added to a table or any field
on the record changes, the effective date field in the record is
automatically updated?

 

[Rick Brandt]

How do I set it up so that whenever a record is added to a table or any field
on the record changes, the effective date field in the record is
automatically updated?

For insertions you can just add a date field with a default value of Now() or
Date() depending on whether you also want the time or not. For changes you
would have to make all of them in a form and use the form's BeforeUpdate event
to set the value of the field to Now() or Date(). There is no way to do that at
the table level.