title: MS Access VBA DoCmd.OpenForm WhereCondition failing with field not found error
body: <p>I am using VBA to open a form. The form has a Crosstab query for the recordsource, if that matters.
  I am trying</p>
  
  <pre><code>DoCmd.OpenForm Form_frmMyForm.Name, , , "ID = 7"
  </code></pre>
  
  <p>(eventually I will replace the "= 7" with something more useful. This is just for testing)</p>
  
  <p>But I get an error when it gets to that line:</p>
  
  <pre><code>Run-time error '3070":
  The Microsoft Access database engine does not recognize 'ID' as a valid field name or expression.
  </code></pre>
  
  <p>I have positively confirmed that the field 'ID' is in my crosstab query. In fact, I use that field in several controls without issue.</p>
  
  <p>I also tried</p>
  
  <pre><code> Form_frmMyForm.Recordset.FindFirst "ID = 7"
   MsgBox (Form_frmMyForm.Recordset.NoMatch)
  </code></pre>
  
  <p>and it shows "False", indicating that there was a match, however, the form does not advance to that record.</p>
  
  <p>Any ideas what I may be missing?</p>