<b>Add Date/Time Stamp when recordset updated</b>

[crjo]

I have a field (EditDate) and I would like it to record the Date & Time when recordset data has been edited/changed.

 

[KenReay]

Hi
If you are updating your table from a bound form, in the before update event:

EditDate = Date()

or if you want date and time

EditDate = Now()

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[crjo]

As usual, the obvious solution is the simplest:

Private Sub SomeField_AfterUpdate()
Me.EditDate.Value = Now()
End Sub