After update question

  • Thread starter Thread starter ljg
  • Start date Start date
L

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.
 
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 ...
 
Use the Before Update event. the After Update is too late, the record
changes have already be applied.
 
Back
Top