Dear All,

I would like to use the value of a variable defined in the module in a report. I created a text box and assigned the control source property to "=[sCurrency]" where sCurrency is the variable defined in the module. This is not recognized and asking for the parameter value for "sCurrency" while running the report, but when I use the same variable in forms it shows the value stored in the variable "sCurrency".

This is very much required as I need to print the currency type in the reports using the public variable.

Could any one give any suggestion for this ?

Thanks in advance.

Bye,

Murali

Hi Murali,

Use a function to return the value of your global variable:



Make the function return the same datatype as sCurrency (I'm guessing it's a string since it's called 's'Currency)

hth,

d