changing date when record is updated

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

Guest

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
 
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()
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount function in access 0
Access How to record date/time when specific field is modified in Access 2007 0
Update UserID and Default Date - Continuous Form 1
Duplicate sub form last record 6
Subform date/time must be greater than date/time of last record 1
Need combo box to refresh when moving to new record 2017 1
Another Question on Subforms 2
Access Property sheet data missing also syntax 0

Back
Top