Use a variable in a query criteria

[discodave101]

I have the variable 'strTrade' that i need to pass into a query so the graph it produces is correct, how do I put the variable in the criteria part of the query?

 

[8Ivy]

Set the query up to use a parameter, then use the QueryDef object to set the parameter.

For example, if your query was stored as myQuery, and had a parameter TradeType:

dim qDef as queryDef

set qDef = currentdb.querydefs("myQuery&quot
qDef.parameters("TradeType&quot = strTrade
qDef.execute 'or openRecordset

Good luck.

-Ivy