After update question

[ljg]

I have a hidden field on a form [df3] and want to update this field with the
current date once a record is changed.

I have added to the forms AfterUpdate:

Private Sub Form_AfterUpdate()
Me.df3 = Now()
End Sub

But this does nor work, can anyone tell me the correct syntax for this
please.

 

[Allen Browne]

Use Form_BeforeUpdate.

There is no point dirtying the record again *after* it has been saved
(Form_AfterUpdate) so it needs to be saved again, which will trigger
Form_AfterUpdate again, which ...

 

[Klatuu]

Use the Before Update event. the After Update is too late, the record
changes have already be applied.