OK, I have a database that works great so far. I have about 80 users all with thier own Usernames and Passwords. Issue is, I want to be able to catch the Username they log in with, and then display it in a textbox on the form they go to after login. Not to good with VBA, but I know it can be done. Please let me know if anyone has any ideas.... Keep in mind, I'm not to good with VBA yet so please explain THANKS.

In case you need it, here is my login code.

Private Sub Command8_Click()
Username.SetFocus

'This will check usernames and passwords in the system
If Username = "Admin" And Password = "123" Then

DoCmd.Close

DoCmd.OpenForm "WrittenStatsForm"

Else
MsgBox "Incorrect Username and or Password"

End If
End Sub