username on a label in form

[AC-Dev]

Good day developers!

Small question. I have a table with employee names, ID's, etc.
When an employee logs in, i take the username from that table and put it into a global variable so i can use it in my switchboard (well at lease i am trying to use it in my switchboard).
On the bottom of my switchboard i have a label and i want it to say "Signed in as: ..." or "Welcome, ......." or whatever it may be.

Basically, how do i pull a variable from my code to use as a label caption?

 

[pbaldy]

You can only refer to the variable directly in code, so you could use the open or load event of the form to set the caption property of the label. You could also create a public function that did nothing but return the value of the variable, and use it in a textbox:

="Welcome, " & FunctionName()

 

[AC-Dev]

You can only refer to the variable directly in code, so you could use the open or load event of the form to set the caption property of the label. You could also create a public function that did nothing but return the value of the variable, and use it in a textbox:

="Welcome, " & FunctionName()

GENIOUS!
Thanks

 

[pbaldy]

Happy to help!