Global variables as criteria (1 Viewer)

[x0reset]

Anyone know how to reference a global variable as criteria for a query?

I am currently using invisible text boxes on an intermediary form as criteria for my query and it works fine, but this solution seems inellegant and I'm looking for something a little smoother. I just need the correct syntax to reference a variable in the criteria section of a query.

Thanks!

 

[x0reset]

Why is it you always find the solution the second after you post? It's fairly simple; just use a period instead of an exclamation point:

Reference a control:

[Forms]![MyForm]![MyControl]

Reference a variable:

[Forms]![MyForm].[MyVariable]

Dont I feel stupid.