Can i clone a record from a table ?

[Sogood]

i wish to clone a record from a table(tbl_cashsale) ~

Dim rs As Object

Set rs = ??

 

[maxmangion]

not sure why you want to do this, but you can create a button on a form and from the wizard choose the "duplicate record"

 

[Sogood]

sorry ~ you misunderstanding

normally ppl use to do like this

Dim rs As Object

Set rs = Forms![ABC].Recordset.Clone

can i direct Clone recordset from a table ?

 

[Sogood]

heihei !! i done it using

Currentdb.Openrecordset ()

btw thanks