以下代码大量参考了911网站的代码

Public Sub CopyRecord(frm As Form, strControlName As String)

On Error Resume Next
Static j As Boolean
Dim D, i As Long

Set D = CreateObject("Scripting.Dictionary")

Dim strSName() As String
strSName = Split(strControlName, ";")

If Not j And frm.NewRecord Then
frm.Recordset.MoveLast
j = True

For i = 0 To UBound(strSName) - 1
D.Add strSName(i), frm.Recordset(frm(strSName(i)).ControlSource).Value
Next i

DoCmd.GoToRecord , , acNewRec

For i = 0 To UBound(strSName) - 1
frm(strSName(i)).Value = D(strSName(i))
Next i

j = False
End If
Set D = Nothing

End Sub

用法，要在current事件中调用，注意是控件名，而不是字段名，并且最后的;号不要忘记加

Private Sub Form_Current()

CopyRecord Me, "控件1;控件2;控件3;" End Sub