Data change recording problem

[kgerlitz]

I want to have the "APUpdated" field populate with the current date and time whenever a change is made to the record. Have used the code below with no success.

Private Sub Form_DataChange(ByVal Reason As Long)
[APUpdated] = Now()
End Sub

When I use this code in the BeforeUpdate it works but it also records the date and time even when I enter the record and leave without making data changes--not exactly what I want.

Any suggesstions

 

[lupins46]

The form_beforeupdate event is the correct event. This event only fires if the data on the form has been changed. It does not fire if you only view the record.

The datachange event fires for certain changes if your form is a pivot table.