我可以添加UI动作确认吗?

您需要在VBA中通过设置标志来处理自动更新。单击按钮后,询问用户并保存答案是否为“是”。

'Set a flag for manual update
Private mIsUserUpdate As Boolean 'Flag

'Cancel auto-update
Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Not mIsUserUpdate Then Cancel = True
End Sub

'Save Button - Change 'YourButtonName'
Private Sub YourButtonName_Click()
    If MsgBox("Are you sure you want to duplicate the record?", vbYesNo + vbQuestion, "Confirm") = vbYes Then
        mIsUserUpdate = True  'flag ON
        DoCmd.RunCommand acCmdSaveRecord
    End If
    mIsUserUpdate = False 'flag OFF again
End Sub