Hi, i cannot solve this error:
Has anybody else had the same issue?

The value cannot be added to this new row, first commit the row and then try adding the value:

Immediate window results:
Form_Current triggered
New record detected, committing changes...
Clearing fields...

Details

Private Sub Form_Current()
    Debug.Print "Form_Current triggered"

    ' If this is a new record, commit the row first
    If Me.NewRecord Then
        Debug.Print "New record detected, committing changes..."
        
        ' Check if the form is dirty and save if needed
        If Me.Dirty Then
            Debug.Print "Record is dirty, saving now..."
            Me.Dirty = False
            DoEvents ' Ensure Access processes the save
        End If

        ' Force-save the record manually
        On Error Resume Next
        RunCommand acCmdSaveRecord
        DoEvents
        On Error GoTo 0
        
        ' Now clear fields safely
        If Me.NewRecord Then
            Debug.Print "Clearing fields..."
            Me.cboInventoryID = Null
            Me.txtProductCode = Null
            Me.txtProductName = Null
        End If
        
    Else
        Debug.Print "Existing record detected, syncing values..."
        
        ' Sync combo box with the Transaction Item field
        Me.cboInventoryID = Nz(Me.[Transaction Item], Null)

        ' Ensure Product Code & Name update correctly
        If Not IsNull(Me.cboInventoryID) Then
            Me.txtProductCode = Nz(Me.cboInventoryID.Column(1), "")
            Me.txtProductName = Nz(Me.cboInventoryID.Column(2), "")
        End If
    End If
End Sub
Copy