automatically recording date

[Guest]

In my form, I want to be able to have the date automatically entered for a
record, after a change or modification is made to an existing record.

 

[Douglas J. Steele]

Add a LastModified Date/Time field to your table.

In your form's BeforeUpdate event, add code to set that field to Now().

 

[Guest]

Use the form's Current event:
Me.txtMyDateField = Date()

 

[Douglas J. Steele]

I don't think that's really what you want. That'll update the date every
time you access it, even if no change was made.

 

[Ron2006]

Try the OnDirty Event


That says a change was made somewhere.

Ron

 

[Douglas J. Steele]

I still think BeforeUpdate is a more appropriate event.