copy a record in a form to a new record

[fedum]

Hi,
I would like to copy the actieve record on a form to a new
record. I tryed the code from MS-KB:
Private Sub Command1_Click()
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.AddNew
rs!CustomerID = "AAAAA"
rs!CompanyName = "AAAAA Company"
rs.Update
End Sub
I have an unique field ProductId and Code. If I use this
code (change the fieldnames) then there is a new record
but I get problems with the above fields. Productcode is
autonummering, code is text.
Thanks,
Marc

 

[Arvin Meyer]

You cannot copy an autonumber (but then you don't have to as a new one fills
in automatically). I'd guess that the text field cannot be pasted because
you probably have a unique index set on it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Isn't there a method to pass this field and to copy all
the others???
Marc.