SQL作为“访问表单"字段的控制源 [英] SQL as Control Source for Access Form field

问题描述

是否可以使用SQL填充访问表单的文本字段的值?

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

我读到不可能仅输入SQL作为控制源.这是真的吗?

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

感谢任何帮助:)

-编辑-

我需要执行此查询；

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

推荐答案

可以肯定这是正确的SQL，但是您可以使用以下函数:
=DLookUp("field_name","table_name","any_fieldname = 'value'")

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

这篇关于SQL作为“访问表单"字段的控制源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！