Need to use public value across standard modules

[arage]

Need to use public value across standard modules
I declared a public variable in a standard code module & need to reference this value in another standard module, how can I do that? Possible?

 

[Travis]

A Public Variable is just that Public.

This means from a Module Standpoint (not a form or report module which is actually a class module) you can reference the Public variable simply by using it in code.

For Public Variables in a Class Module need to have their reference point also identified (which means they have to be activated) in order to reach those variables. Example the Form "MyForm" needs to be open to see the Public variables declared in its Declaration section: Using Forms![MyForm].[Public Variable Name].

HTH

 

[arage]

I get a “variable not defined” error when my standard module tries to access a variable defined as public in some other standard module in the same database.

 

[arage]

oh I get it, I didn’t comment out option explicit in the module.