Why doesn't Access see the function from the module?

Question

Visual Basic

The question is pretty simple.
I wrote a function in the module:

Public Function GetUserName() As String
    ' GetUserName = Environ("USERNAME")
    ' Environ("USERNAME") is easily spoofed, see comment by HansUp
    GetUserName = CreateObject("WScript.Network").UserName
End Function

What do I really need.
When creating a new row in the Table, the function should automatically write the username in the field ...
And I write in the "Default Value" section. =GetUserName()
But Access writes to me that this function does not exist ...
What's the problem?

Answer 1

it turns out that the function is not in the scope of the executable code