How do i populate a login name in ms access on every form the user opens to use

[FOURKAYSDAD]

----- ' MYUSERNAME is a global variable

MYUSERNAME = DLookup("EMPNAME", "USERACCOUNT", "USERNAME = '" & Me.USERNAME.Value & "'") MsgBox (MYUSERNAME)

The above code captures and displays the login name. no problem.

The issue is when the variable (MYUSERNAME) is used in a form it comes out blank. I learnt from a place that i could use TEMPVARS as solution.
My question is : how could tempvars solve this issue for me please? Please give CODE using TEMPVARS and MYUSERNAME


Thanks

[June7]

A textbox expression can reference TempVar variable.

Why don't you research use of TempVars and make an attempt? I never used myself but I understand them just from reading about.

A public function can be called by a textbox expression and that function can provide the MYUSERNAME global value.

=MyUser()

Public Function MyUser()
MyUser = MYUSERNAME
End Function

[Welshgasman]

TBH I would have thought a global variable would work just as well as a TempVar?

[June7]

Access queries and controls cannot see global variables or constants.