Assigning controls not working

[SemiAuto40]

I have a password/login form with the name control as cbox_User_Login_Name. The the next menu form I assign an unbound text field named txt_user to the value that was in cbox_User_Login_Name by placing this:

[Forms]![frm_User_Login]![cbox_User_Login_Name]

in the default value property section. Works fine right... BUT then when I open a 3rd form and try to assign an unbound field to the same string value that I used already in the prior menu form it will not work when I put

[Forms]![frm_User_Login]![cbox_User_Login_Name]

in the default value property section like I had done before.



WHAT THE? Please I'm losing it!

[Rawb]

Is the original Form still open? That's the only thing I can think of. . .

[SemiAuto40]

Actually the original password login form is closed (best I can tell). The second form frm_Menu works, the third does not. I already tried to make a global string variable to hold the UserName but then I can't reference it to use it.

[SemiAuto40]

I found that I can get the similar effect by referencing the control on the 2nd form so cosmetically the text field shows the user that is logged in. SO that is OK I guess.

NOW what all of this has been about is... to make my table which is automatically on its own placing the word "admin" in my UserName field - to instead use the actual login name from an unbound control on my password form. I've read that if the database is not encrypted in Access2010 that CurrentUser() defaults to "admin" and there is nothing in the world that is working for me to remedy that annoying problem!!! But I'm not using CurrentUser() anywhere so that blows my mind.

[Rawb]

One possibility is to create a local table that stores the current user's name in a field.

Then, when someone logs on successfully, their name is saved to the Table which can then be referenced from anywhere.

[SemiAuto40]

Your plan makes more sense with using the user table for what I want to do. Thanx that helped.