Passing a PUBLIC var to a Query

D

Dennis

I have a Public var that I fill from a form. I want to use that public var in
my query (which fills a drop-down list on the same form). How do I do that?

Thanks!
 
O

Ofer

You can create a global function that will return the variable, and you can
use this function in the query

Function MyFunctionName()
MyFunctionName = VariableName
End Function
 
D

Dennis

That did it. Thanks a million!

Ofer said:
You can create a global function that will return the variable, and you can
use this function in the query

Function MyFunctionName()
MyFunctionName = VariableName
End Function
Click to expand...
 
Top