Access 2016 DLOOKUP

Question

如何使用DLOOKUP查找要在表单中使用的表字段？下面是我一直在使用的，但请继续使用#TYPE！错误。

=DLookUp("[ProductName]","[TblProduct]","[TblProduct].[ProductCode] =" & Str([ProductCode_Text].[Text])

Answer 1

您的产品代码需要用单引号括起来：

=DLookUp("[ProductName]","[TblProduct]","[TblProduct].[ProductCode] = '" & Str([ProductCode_Text].[Text] & "'")

Answer 2

非常感谢。我已经修改了代码，它可以工作，但这是最有效的方式吗？

Private Sub Location_AfterUpdate()
Dim filteritem As String
DoCmd.OpenTable "item_Detail"
Me.Units_in_UOM.Visible = True

filteritem = "[ItemId]=" & "'" & Me.Item & "'"
MsgBox (filteritem) ' just for testing need to delete
Me.Units_in_UOM = DLookup("[QPC]", "[Item_Detail]", filteritem)
'Me.Units_in_UOM = DLookup("[QPC]", "[Item_Detail]", "[ItemId]=" & 'filteritem)

End Sub