A way to copy a record to a new record

[John]

Does anyone know a good way to copy a record that a user
is on and when they click on a button, it creates a new
record and copies the information from the selected record
to the new record.

Thank in advance,
John

 

[Reggie]

John there are several ways. Check out good examples below.

'This was found at http://www.applecore99.com/frm/frm022.asp
Private Sub Form_Current()
If Me.NewRecord = True Then
Dim rsClone As Recordset
Set rsClone = Me.RecordsetClone
rsClone.MoveLast
Me!FirstName = rsClone!FirstName
Set rsClone = Nothing
End If
End Sub

Another method found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208824&Product=acc2000

and:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210236&Product=acc2000