Use of public variables

[stonewal]

I have declared a public variable CurrentName in a class module named PubVars. I thought I could use this variable anywhere such as a criteria in a filter or a query but all I get is an "enter parameter value" common dialog box. I am referencing my public variable
[PubVars].[CurrentName]

I am really stumped. Any suggestions?

 

[MichaelRed]

I think (therfore I am {not sure?}).

Oh well, the syntax is more than expected/required. Just use the name part of the var "CurrentName" (no brackets, no module name, and no dot operator)

[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]