**CurrentDb.Execute "UPDATE SStable" & _
"SET [Status of review]='" & Me.Revstats.Value & "'" & _
", [Reviewer]='" & Me.Reviewersname.Value & "'" & _
", [Assessment]='" & Me.Assessments.Value & "'" & _
", [Review Comments]='" & Me.Review_Comments.Value & "'" & _
", [RID]='" & Me.RID23.Value & "'" & _
" WHERE (([RIT] = '" & Me.Reviewspending.Value & "') AND [Processed]= '" & Me.CBOSSP.Value & "';"**代码显示了正确的结果，但是在 table 中没有更新相同的结果
回答1
尝试以下更正：
CurrentDb.Execute _
"UPDATE SStable " & _
"SET [Status of review]='" & Me.Revstats.Value & "'" & _
", [Reviewer]='" & Me.Reviewersname.Value & "'" & _
", [Assessment]='" & Me.Assessments.Value & "'" & _
", [Review Comments]='" & Me.Review_Comments.Value & "'" & _
", [RID]='" & Me.RID23.Value & "' " & _
"WHERE [RIT] = '" & Me.Reviewspending.Value & "' AND [Processed] = '" & Me.CBOSSP.Value & "';"立即窗口 .. 显示参数不是可选的
这表示缺少或拼写错误的 table 或字段名称。