我正在尝试从子报表中删除一行(我的子报表使用了不同表中的不同列值(。但是我遇到了数据类型不匹配错误!
下面是我使用的代码:
CurrentDb.Execute "DELETE FROM StateBudget " & " WHERE S_ID = " & _
DLookup("ID", "States", "State='" & _
Me.subformStateBudget.Form.Recordset.Fields("State") & "'")
我认为S_ID是一个文本值,那么如何将 DLookup 值更改为字符串或文本?
您不需要将 DLookUp 值更改为字符串,您需要将其作为字符串传递给 SQL(用引号引起来(:
CurrentDb.Execute "DELETE FROM StateBudget " & " WHERE S_ID = """ & _
DLookup("ID", "States", "State='" & _
Me.subformStateBudget.Form.Recordset.Fields("State") & "'") & """"