capture CreatedBy in record (1 Viewer)

Hi

I have some VBA code that logs user activity on my database and stores it in a table

I'm trying to display the username in a field when they created a new record.

since i already have this data, what would be the best way to use this?

useractivity table

ID | timestamp | username | activity

is there a pre build function within access for this or am i better off using the data on the table? and if so how?

Use the beforeinsert event of the form to set the textbox.

Private sun Form_beforeinsert()
Me.textbox=environ("username")
' or use the function you have to set the value of textbox
End sub