Can you reference a variable in a query?

[intern42]

Can you reference a variable in a query?

For instance, if I have an integer variable that is populated in a form's modual, can I have the form call a query that looks like:

SELECT ...
FROM ...
WHERE ... = intVariable;

Maybe [Forms]![Form name]![variable name]?

 

[Jack Cowley]

You have to use a function to get the value from a variable in a query:

Public Function MyVarValue ()
MyVarValue = MyVariable
End Function

SELECT ...
FROM ...
WHERE ... =MyVarValue();

hth,
Jack