How to create a variable that can be used in all forms.

[behnam]

Hi all,

can anyone please tell me how I can create a variable that can be used by all forms.



Thank you very much!!

[ranman256]

In a module (I use modGLOBAL) , create a GLOBAL variable:

PUBLIC gsUser as string

[amrut]

Another option is use of TempVars
See here for more http://blogs.office.com/2010/09/27/p...2007-and-2010/

[behnam]

Ranman im not to good at vba so what ur saying is i can create a module and write

PUBLIC gsUser as string

then i am able to use the variable gsUser in everyform?

[ItsMe]

That is the way. Be careful not to try and use it twice simultaneously.

Just before using it
gsUser = ""

And just after finishing
gsUser = ""