I have a login form and I am wondering if the loginID can be saved in a session variable so that it is available to use in other forms.
Right now, I have declared a global variable and assigned the global variable to a local variable in the afterUpdate function of the UserName comboBox in the login page. In the next page, I need to use the loginID, so I have assigned another local variable to the global variable.
For example,
globalVariable = me.form1Combo1.value
me.form2textbox1.value = globalVariable
Now, I need to use the loginID in another page, so I am wondering if the only solution is to again assign the global variable to a local variable in the afterUpdate function or if there is a simpler solution.
I am thinking of a session variable where I can access the loginID in every page. I have done this in java. Not sure of how to acheive it in vba.
Any help would be greatly appreciated