Is there any way to use a global variable in a query?

[vicrauch]

I'm looking for a way to use a global variable in a query. What I have done in the past is used a hidden form to store global variables, then reference the form within the query. But I was hoping that there is a way to use a class variable or a class property in a query.


Any ideas?

[pbaldy]

I don't believe there's any way to use it directly. The usual solution is to create a public function that returns the value of the variable, and call the function from the query.

[vicrauch]

Thanks Paul. Coming from you settles it for me, "Can't be done." I will stick to my hidden form idea that I have used successfully for over 15 years. I've just been away for Access for about 4 years now, so just trying to catch up again. Nice part is, it's coming back quite well.
Vic

[pbaldy]

Happy to help Vic, though your confidence is misplaced. The fact that I don't know how to do something doesn't mean it can't be done.

[vicrauch]

"The fact that I don't know how to do something doesn't mean it can't be done."
But, the fact that nothing pops into your mind, is enough that it more than likely can't be done. At least, is not worthy to be pursued. Plus the fact that I did not think it could be done in the first place, and with you "agreeing," then I'm done looking.