Using a Public Array

[Guest]

I would like to populate an array from a form event, and use the array from
other procedures of the same form. I can't declare the array as public at
the module level, however. Can I make an array accessible to all procedures
in a module?

 

[Douglas J. Steele]

Declare the array in a module (not a class module nor the module associated
with any form or report)

 

[Guest]

that's weird, I wonder why you can't declare it in the form's module...

 

[Douglas J. Steele]

Because what's declared in a form's module is local to that form only.

You can refer to the form to get at public variables defined in the form:

Form_NameOfForm.Array

or

Forms("NameOfForm").Array

However, that only works while the form's open. If you close the form, all
variables disappear.

 

[David W. Fenton]

Because what's declared in a form's module is local to that form
only.

You can refer to the form to get at public variables defined in
the form:

Form_NameOfForm.Array

or

Forms("NameOfForm").Array

However, that only works while the form's open. If you close the
form, all variables disappear.

And you can't do it for arrays, which cannot be a public member of
any kind of class module (including form modules).