SQL as Control Source for Access Form field

Question

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 1

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