Is there a way to set a variable/criteria in a pass through query?
D Duane Hookom Feb 26, 2008 #2 I use a little DAO code to set the SQL property of the saved pass-through query. Something like: Dim strSQL As String strSQL = "SELECT... FROM ... WHERE ID=" & Me.txtID Currentdb.QueryDefs("qsptMyQuery").SQL = strSQL
I use a little DAO code to set the SQL property of the saved pass-through query. Something like: Dim strSQL As String strSQL = "SELECT... FROM ... WHERE ID=" & Me.txtID Currentdb.QueryDefs("qsptMyQuery").SQL = strSQL
