Module Help on getting an Update field to populate with today's date when another field is changed
Posted on 2004-09-28
I've got a project tracking database. Management would like to know when the projects are updated by the employee they are assigned to. I only need a date stamp when any field in the project record is updated. I've created a date field and named it "UpdateDate". I thought my best option would be to put the following code in for each field in the form (There are only 7). However, its not working. Are there other options to get today's date to populate the "Update Date" field whenever a user updates a field within a record? Also, I goofed when I named the fields. I used spaces in the names (example, open date when I should have made it opendate). Do I put quotes or brackets around these field names? Here is the code I tried using.
Private Sub Opened_Date_AfterUpdate()
Me.UpdateDate.Value = Date
Thanks for the help.