Record CLone Issue

hello
Im trying to clone my a record on my form so my user doesnt have to re key all the information twice.
No on has been able to help me.....Im using a data control liked to my access database. now in access their is a dup function...
below is my code but given me errors

much help needed thanks or a example


error:

compile error:
method or data member not found

this points to recordsetclone property?

Private Sub Command12_Click()
Set rstClone = Me.RecordsetClone
rstClone.MoveLast

DoCmd.GoToRecord , , acNewRec

Set rstNew = Me.Recordset

With rstNew

.text88(0) = rstClone.text88(0)


End With

rstNew.Close
Set rstNew = Nothing
rstClone.Close
Set rstClone = Nothing

End Sub

Are you coding inside Access? The recordset clone method is Access-specific and not available in other flavors of VB.

so how would you clone in VB?

well i think everyone is confused... Im just trying to clone or duplicate the record from vb on my form so the user dosent have to re key information a person can have 5 records associated with them.



So if record one has joe smith and he has same information but soem fields different they can click a control to clone or duplicate the record so less rekeying?

Ok so i have 8 feilds in my vb form

Name
Address
City
state
zip
phone
product
order no

Now i want to be able to duplicate(clone the record) so the user wont have to re type the first 6 feilds(easier for the user)...? So a person can have multiple order no and products but with same name, address extc So i want to be able to duplictae the record so less keying and the user would only have to change the product and orderno?



much help needed
im using DAO....