I posted this question in the Database section, but that forum is like a ghost town.

This Update statement stopped working after I added the second and third parameters from the bottom. I get an error message that says there is something wrong with my Update syntax. I checked the db table and everything is ok on that end. Any ideas? I wish Access used T-SQL.

Code:
' CREATE COMMAND AND SET PARAMETERS
        invCmd = New OleDbCommand("UPDATE invMain SET Description2=@desc2, Type=@type, " & _
            "Inventory=@inv, Trigger=@trig, LeadTime=@lead, Size=@size, Cartridge=@cart " & _
            "WHERE (Description1=@part)", invCon)
        invCmd.Parameters.Add("@desc2", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@type", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@inv", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@trig", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@lead", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@size", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@cart", OleDb.OleDbType.Char)
        invCmd.Parameters.Add("@part", OleDb.OleDbType.Char)
        invCmd.Parameters("@desc2").Value = "d2" & Me.uiDescriptionTextBox.Text
        invCmd.Parameters("@type").Value = "ty" & Me.uiTypeTextBox.Text
        invCmd.Parameters("@inv").Value = Me.uiOnHandTextBox.Text
        invCmd.Parameters("@trig").Value = Me.uiTriggerTextBox.Text
        invCmd.Parameters("@lead").Value = Me.uiLeadTextBox.Text
        invCmd.Parameters("@size").Value = Me.uiSizeTextBox.Text
        invCmd.Parameters("@cart").Value = Me.uiCartridgeComboBox.Text
        invCmd.Parameters("@part").Value = "d1" & Me.uiPartNumberLabel.Text