LarsDyrby
asked on
How to set the value of a textbox
I would like to use Environ("Username") to find a value in a table and return this value to a textbox in a form.
Please help me!
Please help me!
ASKER
Copied the code into the controlsource of the textbox
= DLookup("[Center]","[tbl_B rugere]", "[Bruger] = " & Chr(34) & Environ("UserName") & Chr(34) )
but the textbox just shows:
#Name?
= DLookup("[Center]","[tbl_B
but the textbox just shows:
#Name?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me.YourTextBoxName = DLookup("[SomeField]","[So