title: query criteria based on form field
body: <p>So I have a query where I select a field and set the criteria so that it only selects records based on the current value of a particular field in my form. The criteria looks like this.</p>
  
  <pre><code>[Forms]![FORMAL_CERT_REVIEW_CHECK_FORM]![REVIEW_CHECK_ID] 
  </code></pre>
  
  <p>Pretty simple stuff. But I am running into the issue where when I run the query I get the prompt that says I need to enter a value. I know that this usually happens when you set the criteria to something that may not exist or you spelt it incorrectly, but I have checked all of this and it seems like everything looks fine.</p>
  
  <p>I was curious if there is something I could be missing, like a property on the field or something that I have not thought of.</p>