Passing a PUBLIC var to a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

syntax error in JOIN operation 4
Passing Public varialble to a query 5
Var vs Object type 4
C# Reflection List<T> 2
share a form level var with app - but don't make var global? 2
failing at a simple MessageEncoder 2
Global Var in queries 2
To SQL Expert: VBA Function that Calls SQL Query 3

Back
Top