Stupid question number 37 this week!!
I have a form with an unbound text box - this text box is updated on form open with the below code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.SetWarnings False
Dim struserid As String
struserid = Environ("UserName")
Me.UserName = struserid
End Sub
I want the username to then be put into a table, but cannot link the text box to the table.
How do i get the result to go in to the table?
table name is tbIssueLog with a field name of UserName
I have a form with an unbound text box - this text box is updated on form open with the below code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.SetWarnings False
Dim struserid As String
struserid = Environ("UserName")
Me.UserName = struserid
End Sub
I want the username to then be put into a table, but cannot link the text box to the table.
How do i get the result to go in to the table?
table name is tbIssueLog with a field name of UserName