Passing text in same form and other forms

[joym]

i created a login page with 2 fields txtLoginID and txtpassword



When i press ok if the user name and password is correct i open the form [TT form] i push the username for that particular ID to the field me.txtusername on form [TT Form]

Private Sub btn_Ok_Click()

Dim ID As Integer

ID = DLookup("LoginID2", "Login", "Username = '" & Me.txtLoginID.Value & "'")

DoCmd.OpenForm "TT Form", , , , acFormAdd
Forms![TT Form]![txtUser] = Name

End Sub

This works fine intially however the form [TT Form] is used to create new records and has a save button which saves the record if all fields have been filled.

Since it is used to add records after executing the save command. it clears all fields including the me.txtusername.

I want the username of the person logged in to still be displayed until the user logs out.

Also there is a 2nd form [Edit] where you can update the existing TT that have been created. You i have a button to take you back to TT form to create a new record

I want the name of the person who is logged in to be displayed on the TT form in me.txtusername every time after a ticket is lodged or the TT form page is opened.

So basically i want to
1. save the value of me.txtusername and display the same value in the same text field in the new record.
2. if i go to update field i would want to save the value of me.txtusername and when i open TTform from the update form to again display the value

[aytee111]

Keep the login page open and always refer back to it - Forms!LoginPage!txtLoginID - this can be used everywhere without you having to pass it along.

The login can be taken from Environ("username") and does not need to be entered by the user. Then they won't need a password, the table where the users are kept can determine if it is a valid user or not. Passwords get forgotten and should be avoided whenever possible.

[joym]

Umm the login page is only to use to enter username and password and once that is accomplished i donot see why that page should be kept open. and also even if i did leave the login in age open from my understanding it would not work, as my initial code uses the user name to identify the user name and when you click ok to login login is only successful if username and password for that user is correct only then does it send the users name to the textbox me.txtusername.

So even if i did leave the login page open unless the userID is still in the userID text field i do not think it can be used to push user name to the required text field