title: MS Access, Pass through query with complex criteria. Criteria include Select statments and vba functions
body: <p>I currently have multiple queries that query data from a few tables linked through ODBC, and some temporary tables that are edited through the user interface.  I have complex criteria in my queries such as:<br>
  <code>SELECT * from ThingsData<br>
  WHERE (Thing In(SELECT Thing from ListOfThings) AND getThingFlag() = True);
  </code> 
  In this case Thing is a field and ListOfThings is a temporary table that the user defines from the user interface.  Basically, the user puts together a list of the field Thing that he/she wants to filter the data based on and I want to query only the data that matches the Thing values that the user adds to his/her list.  Currently, the data I am querying is in the linked ODBC table, and the temp table ListOfThings is just a regular, local table and everything works peachy. I want to get rid of the linked table and use a pass through query instead.  However, when i do that, unless the criteria is incredibly simplistic, i get an error:  </p>
  
  <p>"ODBC--Call Failed.  Invalid object name ListOfThings."  </p>
  
  <p>If I dont have any criteria it works fine.  </p>
  
  <p>Long story short: In a pass through query, how do I apply criterias that include SELECTs and functions from my modules and just basically filter the pass through table based on data from my local tables?</p>