Store Value of Text Box on Form after Form is Closed

[bconner]

I have a Login form and I would like to store the login in a variable for use on another form how would I go about doing this?

 

[DCrake]

If you create a Public Variable in a standard module first.

Public StrUserName As String

Then before you close the login form you pass the name of the user to this variable.

StrUserName = Me.TxtUserName

Then when you open up the second form

Me.Username = StrUserName

 

[bconner]

Thanks DCrake that worked!