Hi there,
I have a function that gets the name of the user, and it works well:
Public Function GetUserName() As String
GetUserName = CreateObject("WScript.Network").UserName
End Function
I've placed =GetUsername() in a textbox on my form and it comes up, which is great. But how do I make the username a default value in the table? I've tried placing =Getusername() in the default value slot of the field in design view but it says it can't find the function.
I understand it's difficult to make a user-defined function a default value. Is there any way around this?
Marisa