User Name in a text box
PJ -
Use the On Enter method instead of the On Update method, and put in code
like this:
If isnull(Me!txtNotesOnTransaction) Then
Me!txtNotesOnTransaction = CurrentUser()
End If
--
Daryl S
"PJ" wrote:
I have the following code in a memo text field:
Private Sub txtNotesOnTransaction_BeforeUpdate(Cancel As Integer)
Debug.Print "User: " & CurrentUser() & " " & Me!txtNotesOnTransaction
End Sub
I want the current user entering data user name to fill in before typing any
other data.
It is not working any suggestions?
Thanks!!
|