Here is what I have so far
I have a module that has a global variable defined as shown below
Module: initGlobals
-----------------------
This is invoked in a login form("frmLogin") and it displays the above value before I replace it with the one that is accepted in the form.
Here is the code from the login form
When the password is successful, I close the login form and open a form called "frmMainForm". In the form_open event of the "frmMainForm", I am trying to display the user id using strGlobalUserId but it just has spaces. What am I doing wrong?
Appreciate the help in advance. I have searched my entire project for declarations to the above variable. The only place it is declared is in the general module and referenced in the 2 forms that I mentioned above
Thanks
I have a module that has a global variable defined as shown below
Module: initGlobals
-----------------------
Code:
Option Compare Database
Option Explicit
Public strGlobalUserId As String
Sub initvar()
strGlobalUserId = "Myuserid"
End Sub
This is invoked in a login form("frmLogin") and it displays the above value before I replace it with the one that is accepted in the form.
Here is the code from the login form
Code:
strGlobalUserId = Me.cboEmployee.Value
When the password is successful, I close the login form and open a form called "frmMainForm". In the form_open event of the "frmMainForm", I am trying to display the user id using strGlobalUserId but it just has spaces. What am I doing wrong?
Appreciate the help in advance. I have searched my entire project for declarations to the above variable. The only place it is declared is in the general module and referenced in the 2 forms that I mentioned above
Thanks