Pass-thru Queries

[Melinda]

Is there a way to set a variable/criteria in a pass through query?

 

[Duane Hookom]

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