Variable Scope. 1

[Ed2020]

Anybody any idea what the difference between a Global variable and a Public variable is? As I understand it:

Dim - available only within the current procedure
Private - available to all procedures in the current module
Public - available to all procedures in all modules
Global - available to all procedures in all modules.

So what's the difference between Public and Global??

Ed Metcalfe.

 

[jgoodman00]

Public is available to all procedures in all modules if in a module.
If a variable is declared as public from a class module, it is only available whilst the form or report to which the class module belongs is open.
Public class modules are referenced in the form of "Form_frmName.Variable"

James Goodman

 

[Ed2020]

Cheers James,

So if a variable is declared as Public in a standard module there is no difference between it and a Global variable?

Ed Metcalfe.

 

[jgoodman00]

if you type in global, select it & then press F1, the access help loads the help file associated with the Public declaration. I would therefore assume Public & Global to be the same in their use. James Goodman

 

[Ed2020]

Cheers James.