Is there a way to use global variables in reports and queries?
K Ken Snell [MVP] Jul 12, 2005 #2 In a report, you can refer to the variable by name. In a query, you must call a public function that returns the value of the variable: Public Function GetVariableOne() GetVariableOne = NameOfYourVariable End Function
In a report, you can refer to the variable by name. In a query, you must call a public function that returns the value of the variable: Public Function GetVariableOne() GetVariableOne = NameOfYourVariable End Function
