Hello,

I just simply want to append a clone record. Basically, I cloned a record
then modified couple of fields and then I wanted to append this modified
record to the table.

----------------------------------------------------------------------------
-----------------------------
Dim curRec As Recordset

'modify current record
Set curRec = Me.RecordsetClone
curRec.Fields(DSCRIPTION).Value = "Blah blah blah blah blah"
curRec.Fields(DUE_DATE).Value = curRec.Fields(DUE_DATE).Value - 45

'Now I wont to append the modified record to the database
' I've tried something following but I got error : "Can't assign to read
only property"
Me.AllowAdditions = True
????????
Me.NewRecord = curRec
????????
----------------------------------------------------------------------------
-----------------------------

Any help is greatly appreciated,
Tom

Would you please stop multiposting!!
If you need to post to more than one group at a time then Crosspost by
including all of the NG's at once in the Address line!
--


Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"tom" <(E-Mail Removed)> wrote in message
news:2S2xc.8368$(E-Mail Removed)...
> Hello,
>
> I just simply want to append a clone record. Basically, I cloned a
record
> then modified couple of fields and then I wanted to append this
modified
> record to the table.
>
> ----------------------------------------------------------------------
------
> -----------------------------
> Dim curRec As Recordset
>
> 'modify current record
> Set curRec = Me.RecordsetClone
> curRec.Fields(DSCRIPTION).Value = "Blah blah blah blah blah"
> curRec.Fields(DUE_DATE).Value = curRec.Fields(DUE_DATE).Value - 45
>
> 'Now I wont to append the modified record to the database
> ' I've tried something following but I got error : "Can't assign
to read
> only property"
> Me.AllowAdditions = True
> ????????
> Me.NewRecord = curRec
> ????????
> ----------------------------------------------------------------------
------
> -----------------------------
>
> Any help is greatly appreciated,
> Tom
>
>
>