Set adoRs = adoCon.Execute("UPDATE shortagedata SET [Yes_Or_No] = '" & xx & "', [Material_Infromation] = Now() & '" & Me.Inf(6).Text & "'  where PN = '" & Me.TVW.SelectedItem & "' and IA = '" & Me.Combo1.Text & "'")

Set adoRs = adoCon.Execute("UPDATE shortagedata SET [Yes_Or_No] = '" & xx & "' where PN = '" & Me.TVW.SelectedItem & "' and IA = '" & & "'") 没有问题,
加了这个[Material_Infromation] = Now() & '" & Me.Inf(6).Text & "' 就不知道代码错在哪?

[ 本帖最后由 yuk_yu 于 2010-8-3 17:16 编辑 ]

去掉就可以？

我要增加个修改项目啊

UPDATE shortagedata SET [Yes_Or_No] = '', [Material_Infromation] = Now() & Me.Inf(6).Text '  where PN = 'Me.TVW.SelectedItem ' and IA = '‘

这是你的SQL语句
首先这两个字段为什么要加引号？
还有其它的’或者“估计也有问题，你自己检查一下