Show username - Microsoft Access Forum


	Back to Access Forum Comments List

Show username

Robert Freeman

2 years ago

Hi. I have a login form table that lists a UserName, Password and UserFullName fields.
I have login form and the database working and TempVars is used to determine the user's access level to the various database elements.
However, I'm drawing a blank on how to display the UserFullName in a field on the database main form based on the UserName held in TempVars.
Any help would be appreciated. Thanks.

	Adam Schwanz @Reply 2 years ago
Just set the textbox control source =TempVars('yourname') Use double quotes though, phone wont post proper double quotes.

	Robert Freeman OP @Reply 2 years ago
Hi. I have already done that and, very correctly, it shows the 'UserName'. The user name could be Admin but what I want to show on the form is the 'actual' person's name which is stored in another field of the UserName Table. So, for example, if the 'Admin' is the user I want to show their proper name e.g. James Kirk (where have we seen that before 😂).

	Adam Schwanz @Reply 2 years ago
`=DLOOKUP("RealName","UserT","UserName=""" & TempVars("UserName") & """")` DLookup

	Robert Freeman OP @Reply 2 years ago
Adam. Thank you, that works fine. For some reason I have this mental block with DLOOKUP. I will watch Richard's videos again. Regards. Bob

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen