Displaying login in name in the field of next form

[prasadmng555]

Hi,

I have login form created which I login with user name. I want to display the same login name in a field of a form after I login.

Can someone help me on this plz.

Many thanks,


PK

[Homegrownandy]

Assign it to a global variable.

Its almost like I know what I'm doing. No, but seriously. If that value is held as a global variable once logged in, you can use it throughout your database.

I'm no expert and I probably wont be much use beyond this, but if you're stuck at least you have something to look at now.

[cbende2]

It can be as simple as minimizing the login form after logging in, and using-- Forms![YourLoginForm]![YourUsernameTextBox] wherever you want that value.

If FormA is your login form, and FormB is your form you want to display your login username in the textbox named MyTextbox, set the MyTextBox control source " =Forms!FormA![YourUsernameTextBox]"

[orange]

You could also use a Temporary variable.

Good luck.

[redekopp]

we use code like this. the Login button code has:

 TempVars.Add "EmpCode", Me.cboEmployee.Value
        DoCmd.OpenForm "Switchboard"

cboEmployee is your usename.

on the "switchboard" we created a text field with the control source =[TempVars]![EmpCode]

Hope that helps!