SQL as Control Source for Access Form field

Is there any way populate an Access Form’s text feild’s value using SQL?

I have read that it is not possible to simply enter SQL as the Control Source. Is this true?

thanks for any halp 🙂

–edit–

I need to perform this query;

SELECT tblCaseIssues.IssueDesc FROM tblCaseIssues INNER JOIN tblCaseNewHS_Issues ON tblCaseIssues.ID = tblCaseNewHS_Issues.IssueID WHERE(tblCaseNewHS_Issues.HS_ID = 81))

Answer

Pretty sure that is true SQL, but you could use the function:
=DLookUp("field_name","table_name","any_fieldname = 'value'")