Global Variable

[dodgyone]

I have two forms... what I would like is to to store UserID from the second form asa variable. From the first form I would like to be able to call this variable as necessary.

Could you please give me any help\examples about doing this, keeping it as simple as possible. It's just that all of he examples juts seem to give a little buit of the answer ;o|

Thanks....

 

[JoeMiller]

Go into a module and place a line to "dim" your global variable like so:


Global gvarUserID As String


Now in your forms code you just treat gvarUserID as any variable you would normally use. It can be called anywhere and everywhere, just make sure you set it equal to something so that you can use it. Like so:

gvarUserID = CurrentUser


Hope that helps!
Joe Miller
joe.miller@flotech.net