Set Global user name with a table field

[msilva100]

The scenario: I take the user id from a login form and match the the user id in a table to get the users first name. The set in global variable with users first name---so all the forms the user opens display Users first name.
Thanks in advance for your help.

[Seth Schrock]

I would store the value in a temporary variable (aka TempVars) when you get it from the table. Then you can set the value of your textbox to the value stored in the TempVar in the form's OnLoad event.

[msilva100]

Seth thank you so much for sharing. I just wish I had posted this 4 days ago. I have been reading volumes of books and came up empty every time.

Problem solve have a great week!!!

[Seth Schrock]

Glad to be able to help. Good luck on your project.