Text box changes

[FACTOR 21]

I have a text box that pulls the Windows User Id into a form, I need this to set once a new record is created and not to change when someone else views the record.

The user id is pulled via a module and this module is referenced in the default value field on the Data tab of the properties sheet.

Public Function getWinUser() As String
getWinUser = Environ("UserName")
End Function

Thanks in advance

 

[Joe4]

I need this to set once a new record is created and not to change when someone else views the record.

Then you want to store it in a field in an underlying table, so that the field is "bound".
That is the only way to have it remember the value.