changing date when record is updated

L

LtFass

Ok I looked through the all of the posts and really didnt find answer. I have
a table that has a field "strDate" that holds the date the record was
entered. The default value of the field is set to Date(). All works well as
long as only a new record is entered. What I want to do is change that date
automaticly if the record is changed in anyway. The record only contains five
fields. The data is entered via a form in data sheet view.

Thanks Cliff
 
A

Allen Browne

If your data is only changed in a form, you can use the form's events to do
this. Otherwise it can't be done with the tables in Access, since it lacks
triggers.

In a form, just include this line in the BeforeUpdate event of the form:

Me.strDate = Date()
 
L

LtFass

Thanks again Allen,
Deep down I suspected that was the answer but I thought I would ask just to
be I hadn't missed something. Thanks again
Cliff
 
Top