Keeping users name on forms

[b_best]

I have created a job tracking database. When opened the user picks there name from a drop down, enters there password and then they go to a form that shows them in a datasheet all there jobs. There name is at the top of this form. There is a button called "New tasks" when you click this it opens a new form with fields to fill out to put a new task in the system.



What I am having a hard time with is getting the second form to know who you are. Right now they have to pick there name again from a drop down. I would like this 2nd form to remember who I am from loging in. Any Help?


Logon -- Form 1 (name is fine) -- Form 2 (does not remember name)

[RuralGuy]

Rather than closing the Logon form, I would just make it invisible. Then any form can access it for the user information.

[b_best]

Ok, I do have the logon form stay in the background. I quess my question is, do I need to add code into the 2nd form to make it retreve the information I want?

[RuralGuy]

Here's a reference for the syntax to fetch values from another loaded form. The form need not be visible, just loaded. http://access.mvps.org/access/forms/frm0031.htm

[b_best]

looks like that should Help Thank for the information.

[RuralGuy]

If you need further assistance, just post back here; otherwise you can mark the thread as Solved at the top of the thread under Thread Tools.