declaring a public variable...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

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...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why can't "public txtWrk_From as string" be found in another modu. 1
form variable 2
Public Variable Scope 3
VBA CODE HELP! 0
global variable 3
Public Variables 2
Declaring Variables 3
Public variable declaration and usage 2

Back
Top