Seems Simple!?!

[WackyWaterGuy]

Hi there! Ok, so I am pretty well certain that I am not the first person to ask this on here....but doing a search for "Textbox" brings up a billion results. Kinda hard to sift through them all. Hopefully someone can help me out.

Basically, what I have done is set up a login screen, in which the user can put in a username and password. If there username and password are correct, then the login screen is hidden, and a main form opens. On the main form, I would like to have a textbox which displays there name

(For exampe: Welcome ____(Their Name Here)___).

Now, I can easily get it to display their username here by refering back to what they physically entered in the username textbox on the login form, but I would like it to display their Full name (which is in the same table as the user name). I am sure there is a way to do this...it seems easy enough...I am just not great at using textboxes.

Any help would be really appreciated it!

Thanks!

WWG

 

[WayneRyan]

WWG,

You can use an unbound text box on your form.

Use the OnOpen event of your form:

Dim UserFullName As String
UserFullName = DLookUp("[UserFullName]", "tblUsers", "UserName = '" & Forms![LoginForm]![Username] & "';")
Me.YourNewTextBox = "Welcome " & UserFullName

hth,
Wayne

 

[WackyWaterGuy]

Thank you very much! It is working exactly how I had pictured it now!

Muchly Appreciated!

Thanks again

WWG