SQL as Control Source for Access Form field

ms-access, sql, vba

Solution

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

Problem

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)) ```

Original source