Try the following code in your form

[jfischer]

Try the following code in your form:

Private Sub Form_BeforeInsert(Cancel As Integer)
  Me!UserID = CurrentUser
End Sub

 

[Aivars]

Better is:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!UserID = CurrentUser
End Sub

In such case user who updates data each time will be registered
Aivars

 

[jfischer]

Thanks, but matpj had requested that updates NOT overwrite the original record.

 

[JoeMiller]

Use the before update, but only add the record when it's a new record by testing the Dirty property of the form:

If Me.Dirty = True Then
Me!UserID = CurrentUser
End If

HTH Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

I'm sorry I messed up!! Use the NewRecord property of the form NOT dirty.

If Me.NewRecord = True Then
Me!UserID = CurrentUser
End If

HTH Joe Miller
joe.miller@flotech.net