Updating Current User and Date 2

[dabones99]

I have created a form to accept data from the user. I have two hidden text boxes that update the Current User and Date. When a new record is added everything works fine but when I am making changes to an existing record those two fields retain the old date and the old User.

How can I get those two fields to be updated when I am just editting a record? Please help.

Marlon

 

[kevinf2349]

I use the Before_update event for the form to change to the new value

ie.

Private Sub Form_BeforeUpdate(Cancel As Integer)
[Last Updated] = Now 'Set time and Date
[Updated by] = "(" & Environ("Username&quot & &quot"
End Sub

 

[dabones99]

Thanks Kevin

Worked like a charm.