title: SQL as Control Source for Access Form field
body: <p>Is there any way populate an Access Form's text feild's value using SQL?</p>
  
  <p>I have read that it is not possible to simply enter SQL as the Control Source. Is this true?</p>
  
  <p>thanks for any halp :)</p>
  
  <p>--edit--</p>
  
  <p>I need to perform this query;</p>
  
  <pre><code>SELECT tblCaseIssues.IssueDesc FROM tblCaseIssues INNER JOIN tblCaseNewHS_Issues ON tblCaseIssues.ID = tblCaseNewHS_Issues.IssueID WHERE(tblCaseNewHS_Issues.HS_ID = 81))
  </code></pre>