Adding dates to comments

[edortiz]

I have a database that tracks office projects and everytime someone updates the project I need the system to track the date the porject comment was entered.

Everytime I try to do this it freezes my database.

Any suggestions.

Filed = Comments (Notes)
Date= CommentDate (Date/Time)

Thank you.

[Tanis]

What is the code you are using and what event have you used?

[AricC]

Why don't you add another column to the table and set the default date to Now() then when someone enters a new project it will automatically add the date for you.

[MMcCarthy]

You could put an after update event on the comments control on data entry form.

Private Sub Comments_AfterUpdate()
   Me.CommentDate=Format(Now(),#mm/dd/yyyy#)
End Sub

It all depends on how the comments field is being updated. If I remember correctly a Notes data type is the equivalent of a memo field in Access and it can cause problems.