Have Access database where I would like the user to login. Have the screen for the user to login.
What I need help on is setting the "global" variable so throught the project I know who is logged in. I created a Modudle called GlobalVar and all that is in it is:
Global iUser as Integer
I call it in the OnOpen of my Login form:
DoCmd.OpenModule "GlobalVar"
But when I reference the iUser variable, it says "Ambiguous name dected: iUser"
What am I missing or is there a better way to achieve the samething?
Thanks
What I need help on is setting the "global" variable so throught the project I know who is logged in. I created a Modudle called GlobalVar and all that is in it is:
Global iUser as Integer
I call it in the OnOpen of my Login form:
DoCmd.OpenModule "GlobalVar"
But when I reference the iUser variable, it says "Ambiguous name dected: iUser"
What am I missing or is there a better way to achieve the samething?
Thanks