send parameters in pass-through query

[mghafoori]

How can i use parameters in a pass-through query. I know you can use & to get the user to enter a parameter in Oracle, but I can't use that in Access Pass-through. any help?

 

[mdthornton]

The easiest way to do this is in VB. Build the SQL string including your new parameters and then set it to the SQL property of the query definition. Eg

set qdf= myDB.queryDefs("myPassThru&quot
sNewSQL = "select a,b,c from x where y = " + Cstr(me.parm)
qdf.SQL = sNewSQL Good Luck,
Mike T