Copy records from form as new records

[Dixie]

I have a continuous form with a variable number of records showing on it.
Each record has about 8 fields. I want to be able to copy all of these
records, then paste them to the underlying table with a different ID number
to the ones they already have. I can pick up the required ID number from a
text box on the form. I have tried to do it with a recordset and rs.AddNew,
but it stops after the first record is copied. Is there a simple way to
accomplish this?

dixie

[Tom van Stiphout]

On Tue, 19 Jul 2005 12:26:27 +1000, "Dixie" <di***@dogmail.com> wrote:

Why not use an Append query? Obviously there already is a query to
pull the current records. It can be the starting point of an Append
query that copies those records, with a bit of smarts to fix the ID
values.

-Tom.

I have a continuous form with a variable number of records showing on it.
Each record has about 8 fields. I want to be able to copy all of these
records, then paste them to the underlying table with a different ID number
to the ones they already have. I can pick up the required ID number from a
text box on the form. I have tried to do it with a recordset and rs.AddNew,
but it stops after the first record is copied. Is there a simple way to
accomplish this?

dixie