I have an Update SQL statement that I'm getting an error on.
DoCmd.SetWarnings False
UpSQL = "UPDATE tblTerminal SET tblTerminal.TerminalName = " & Chr(34) & Forms!frmBSTerminalNames!TxtStation & Chr(34) & ", " & _
"tblTerminal.TerminalActive = Forms!frmBSTerminalNames!ChkLocked, " & _
"tblTerminal.TerminalLocation = Forms!frmBSTerminalNames!TxtLocal, " & _
"tblTerminal.TerminalAddress = Forms!frmBSTerminalNames!TxtIP, " & _
"tblTerminal.TerminalTypeID = Forms!frmBSTerminalNames!TxtType, " & _
"tblTerminal.TerminalTouch = Forms!frmBSTerminalNames!ChkTouch " & _
"WHERE tblTerminal.TerminalID = Forms!frmBSTerminalNames!TxtID;"
DoCmd.RunSQL (UpSQL)
DoCmd.SetWarnings True
Its TerminalActive, it gets its value from a checkbox which is either 0 or -1 The field value in the table is set to Yes/No.....Is this wrong or is the SQL statement wrong. Thanks
DS