simple tracking

[sk88]

So I am interested in knowing who created the record and who changed it.



I followed the examples from one of the website but I can't seem to get it work.

I have added the below fields to my table and query:
CreateBy Text
CreateDate DateTime Default value =Now()
ModBy Text
ModDate DateTime

and I added the codes to the current and before update events of the form

Private Sub Form_BeforeUpdate(Cancel As Integer)
 ModBy = Environ("username")
    ModDate = Now()
End Sub

Private Sub Form_Current()
 If Me.NewRecord Then
        CreateBy = Environ("username")
    End If
End Sub

This is what was stated in the examples but it is not working.
Any idea anyone?

Thanks!

[sk88]

To add to that.. I have a start form which asks for Login and Password before they could enter to the form above.

[orange]

What exactly happens? Error, wrong data?
This isn't very helpful

but it is not working.

[sk88]

What exactly happens? Error, wrong data?
This isn't very helpful

Sorry, not wrong data nor does it gives me error message. It is just not saving the Createby/Username to the table/query.

The only thing that is saved is CreateDate

Maybe I did not link it properly?

[orange]

What is the Table name involved? You have to explicitly update the Table, unless you are using a bound form.

[sk88]

What is the Table name involved? You have to explicitly update the Table, unless you are using a bound form.

It is a bound form. The form is linked to a table called 'METRICS'
and the username and password is in a table called 'tblEmployees'

Maybe I should use unbound form instead?