Update Command Concurrency error - Specific Help

I get a concurrency error when I update my table.  If I ad a new record via "INVENTORY_DRIBindingSource.AddNew()" and then Me.INVENTORY_DRIBindingSource.EndEdit()
        Me.INVENTORY_DRITableAdapter.Update(Me.DIMMSDataSet.INVENTORY_DRI).  All Works fine.  If I open up that specific record & make a change then run:
Me.INVENTORY_DRIBindingSource.EndEdit()
        Me.INVENTORY_DRITableAdapter.Update(Me.DIMMSDataSet.INVENTORY_DRI)
I get the error. Below is my FillByID code...maybe that is the issue.

SELECT     INVENTORY_DRI.PartID, INVENTORY_DRI.PartName, INVENTORY_DRI.PartDescription, INVENTORY_DRI.StockingUnits, INVENTORY_DRI.Location, 
                      SUM(TRX_ROW_DRI.PartsMade - TRX_ROW_DRI.QtyBad) AS PartBalance, INVENTORY_DRI.ID, INVENTORY_DRI.UnitWeight, 
                      INVENTORY_DRI.PartNumber, INVENTORY_DRI.UPC_SKU, INVENTORY_DRI.ItemType, INVENTORY_DRI.ReOrderQty, INVENTORY_DRI.PrefVendor, 
                      INVENTORY_DRI.InActive, INVENTORY_DRI.Offsite, INVENTORY_DRI.OffsiteLocation, INVENTORY_DRI.CostPerUnit, INVENTORY_DRI.DefPurch, 
                      INVENTORY_DRI.Location2
FROM         INVENTORY_DRI LEFT OUTER JOIN
                      TRX_ROW_DRI ON INVENTORY_DRI.PartID = TRX_ROW_DRI.PartID
GROUP BY INVENTORY_DRI.PartID, INVENTORY_DRI.PartName, INVENTORY_DRI.PartDescription, INVENTORY_DRI.StockingUnits, INVENTORY_DRI.Location, 
                      INVENTORY_DRI.ID, INVENTORY_DRI.UnitWeight, INVENTORY_DRI.PartNumber, INVENTORY_DRI.UPC_SKU, INVENTORY_DRI.ItemType, 
                      INVENTORY_DRI.ReOrderQty, INVENTORY_DRI.PrefVendor, INVENTORY_DRI.OffsiteLocation, INVENTORY_DRI.InActive, INVENTORY_DRI.Offsite, 
                      INVENTORY_DRI.CostPerUnit, INVENTORY_DRI.DefPurch, INVENTORY_DRI.Location2
HAVING      (INVENTORY_DRI.ID = @Param1)
 
UPDATE COMMAND:
 
UPDATE    INVENTORY_DRI
SET              PartID = @PartID, PartName = @PartName, PartDescription = @PartDescription, UnitWeight = @UnitWeight, StockingUnits = @StockingUnits, 
                      PartNumber = @PartNumber, UPC_SKU = @UPC_SKU, ItemType = @ItemType, Location = @Location, Location2 = @Location2, 
                      ReOrderQty = @ReOrderQty, PrefVendor = @PrefVendor, InActive = @InActive, Offsite = @Offsite, OffsiteLocation = @OffsiteLocation, 
                      CostPerUnit = @CostPerUnit, DefPurch = @DefPurch, PartBalance = @PartBalance
WHERE     (ID = @Original_ID) AND (PartID = @Original_PartID) AND (@IsNull_PartName = 1 AND PartName IS NULL OR
                      PartName = @Original_PartName) AND (@IsNull_PartDescription = 1 AND PartDescription IS NULL OR
                      PartDescription = @Original_PartDescription) AND (@IsNull_UnitWeight = 1 AND UnitWeight IS NULL OR
                      UnitWeight = @Original_UnitWeight) AND (@IsNull_StockingUnits = 1 AND StockingUnits IS NULL OR
                      StockingUnits = @Original_StockingUnits) AND (@IsNull_PartNumber = 1 AND PartNumber IS NULL OR
                      PartNumber = @Original_PartNumber) AND (@IsNull_UPC_SKU = 1 AND UPC_SKU IS NULL OR
                      UPC_SKU = @Original_UPC_SKU) AND (@IsNull_ItemType = 1 AND ItemType IS NULL OR
                      ItemType = @Original_ItemType) AND (@IsNull_Location = 1 AND Location IS NULL OR
                      Location = @Original_Location) AND (@IsNull_Location2 = 1 AND Location2 IS NULL OR
                      Location2 = @Original_Location2) AND (@IsNull_ReOrderQty = 1 AND ReOrderQty IS NULL OR
                      ReOrderQty = @Original_ReOrderQty) AND (@IsNull_PrefVendor = 1 AND PrefVendor IS NULL OR
                      PrefVendor = @Original_PrefVendor) AND (@IsNull_InActive = 1 AND InActive IS NULL OR
                      InActive = @Original_InActive) AND (@IsNull_Offsite = 1 AND Offsite IS NULL OR
                      Offsite = @Original_Offsite) AND (@IsNull_OffsiteLocation = 1 AND OffsiteLocation IS NULL OR
                      OffsiteLocation = @Original_OffsiteLocation) AND (@IsNull_CostPerUnit = 1 AND CostPerUnit IS NULL OR
                      CostPerUnit = @Original_CostPerUnit) AND (@IsNull_DefPurch = 1 AND DefPurch IS NULL OR
                      DefPurch = @Original_DefPurch) AND (@IsNull_PartBalance = 1 AND PartBalance IS NULL OR
                      PartBalance = @Original_PartBalance)

Select allOpen in new window