B Brad Pears Nov 15, 2004 #1 I want a variable to be accessiblein all forms/modules within my app. Where do I declare it? I am having problems with the scope...
I want a variable to be accessiblein all forms/modules within my app. Where do I declare it? I am having problems with the scope...
M Marshall Barton Nov 15, 2004 #2 Brad said: I want a variable to be accessiblein all forms/modules within my app. Where do I declare it? I am having problems with the scope... Click to expand... If you use Public variable ... in the declarations section of a standard module, the variable will be available in all VBA modules. To make it available in queryies or text box expressions. you have to create a Public function in a standard module that returns the variable's value: Public MyVar As whatever Public Function GetMyVar() GetMyVar = MyVar End Function
Brad said: I want a variable to be accessiblein all forms/modules within my app. Where do I declare it? I am having problems with the scope... Click to expand... If you use Public variable ... in the declarations section of a standard module, the variable will be available in all VBA modules. To make it available in queryies or text box expressions. you have to create a Public function in a standard module that returns the variable's value: Public MyVar As whatever Public Function GetMyVar() GetMyVar = MyVar End Function
