A way to copy a record to a new record

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top