title: Compile Error "Method of Data Member Not Found" - DoCmd.Query Form Access SQL
body: <p>I'm sure this is pretty simple but I'm still in the early phases of learning how to use VBA in access. I'm not sure what I've messed up on but this is what happened:</p>
  
  <p>I have a form with a combination of lists and combo boxes. I've made a command that returns an SQL query, in its original table form, when a double click is made on a list. When I originally wrote the code it only had 2 fields, a number and a dollar figure. The code: </p>
  
  <p><code>Private Sub List43_DblClick(Cancel As Integer)</code></p>
  
  <p><code>DoCmd.Query ("BuyerPerfDetailPA2")</code></p>
  
  <p><code>End Sub</code></p>
  
  <p>Worked when there where 2 fields, but i have recently added a third, a Yes/No response in column 3. Now, when I run this code, I receive a "compile error" listed in the title. My guess is the added column it cannot match - as the Query has a WHERE clause (<code>WHERE (((CombineTables.[PA#])=Forms![Buyer Performance Report]!List43)</code>. The PA# is assigned to the first column on the list (dollar amount is 2, and yes/no is 3) 3.</p>
  
  <p>After the error, when I press OK it does appear however that the query has ran, so it may also be just a problem access is having with VBA. </p>
  
  <p>Any suggestions? I hope this wasn't too murky. </p>