Global Variable 1

[Watermelon]

Hi,

This might be a stupid question but I'm just trying to create a globabl variable on one form that I can call from other forms. I'm kind of new to Access and I'm not sure how to do this.

Thanks for any help,
TM

 

[Rohdem]

Declare the variable in a module, then you can access it from any form. Mike Rohde
rohdem@marshallengines.com

 

[Watermelon]

Hi,

Thanks Rodhem. I tried that but somehow when I call the variable from another form it's coming up as an empty string. Do I have to assign the variable a value in the Module?
Thanks

 

[Rohdem]

No, you shouldn't have to assign a value to it in the module. Try putting 'public' in front of it:

Public variablename As String Mike Rohde
rohdem@marshallengines.com

 

[Rohdem]

One more thing, don't put it inside a sub or function. Declare it right beneath the 'Option Explicit' line. Mike Rohde
rohdem@marshallengines.com

 

[Watermelon]

Thanks,

Yeah, it does work now. I think I was missing the 'Public.'

Thanks again,
TM