Where do I decalre vaiables who's scope will be global ?

[Malcolm Hind]

Thanks

 

[Douglas J. Steele]

As Public in a stand-alone module (as opposed to a module associated with a
form)

 

[Malcolm Hind]

As Public in a stand-alone module (as opposed to a module associated
with a form)

Thanks Douglas - how would I declare a Module that was or was not linked
with a form ?

Thanks

 

[Rick Brandt]

Thanks Douglas - how would I declare a Module that was or was not linked
with a form ?

In the db window there is a Modules tab just as there is a tab for Forms,
Reports, etc.. On the Modules tab you press [New].

 

[Isis]

Thanks Douglas - how would I declare a Module that was or was not
linked with a form ?

In the db window there is a Modules tab just as there is a tab for
Forms, Reports, etc.. On the Modules tab you press [New].

Thanks for the reply Rick - I eas actually wondering what makes a module
attached to a form and one that is NOT attached to a form ? Whats the
difference when you are making them ?

Thanks

 

[Rick Brandt]

Thanks for the reply Rick - I eas actually wondering what makes a
module attached to a form and one that is NOT attached to a form ?
Whats the difference when you are making them ?

When you create a Form/Report the first time any code is attached to an
event the Module is automatically created. *You* never actually create a
Module on a Report or Form. Modules that you see as separate objects in the
db window are there because you created (or imported) them. Form and Report
Modules are "part of" the Form/Report itself.

In other words, if you see a Module in the db window then by definition it
is NOT a Form/Report Module.

 

[Isis]

When you create a Form/Report the first time any code is attached to
an event the Module is automatically created. *You* never actually
create a Module on a Report or Form. Modules that you see as separate
objects in the db window are there because you created (or imported)
them. Form and Report Modules are "part of" the Form/Report itself.

In other words, if you see a Module in the db window then by
definition it is NOT a Form/Report Module.

Thanks for that clarification Rick.

Regards