Duplicate record

[MrDummy]

Hello,

With below Code I look up a record and is then shown in a form. This is defined as a standard form. Next is that I what to have this record added as new record to the same table (so it can be ammended to the users needs) but for some reason I cannot make it work. MMDGFID is Autonumber. Any suggestions?

Private Sub FindStandardDGD_Click()


Dim rst As Recordset


Set rst = Forms![frmStartScreen].Form.RecordsetClone


rst.FindFirst "MMDGFID = " & Me.MMDGFID


Forms![frmStartScreen].Form.Bookmark = rst.Bookmark


rst.Close

'needs some code here I think

DoCmd.GoToRecord , , acLast

Set rst = Nothing

End Sub

[RuralGuy]

What is the name of the form in which this code is located?