referring to a public Variable in a control or Query

[Guest]

Is it possible to refer to a public variable declared at module level in a
query and in a control (both report and form).

 

[RoyVidar]

jalewis999 wrote in message

Is it possible to refer to a public variable declared at module level
in a query and in a control (both report and form).

Not directly, but through a public function residing also in a standard
module.

public function GetMyVariable() as <your data type>
GetMyVariable = g_MyPublicVariable
end function

Then refer to that function both in the query and report. Note again,
that the function must reside in a standard module, not a forms/reports
module.

 

[Wolfgang Kais]

Hello "jalewis999".

Is it possible to refer to a public variable declared at module
level in a query and in a control (both report and form).

No. You will have to create a function in a publi module that returns
the value stored in the variable and use this function in your query
or control.

 

[Guest]

Thanks problem solved

jalewis999 wrote in message


Not directly, but through a public function residing also in a standard
module.

public function GetMyVariable() as <your data type>
GetMyVariable = g_MyPublicVariable
end function

Then refer to that function both in the query and report. Note again,
that the function must reside in a standard module, not a forms/reports
module.