Record Additions / Changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Bill Cormier said:
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?
Click to expand...

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.
 
Back
Top