Duplicating records from one table to itself

  • Thread starter Thread starter Goldar
  • Start date Start date
G

Goldar

I have developed a data entry form for my customer's accounting application.
This for has a controlsource that is the accounting transactions table. I
have been asked to provide a capability to copy the record being displayed on
the screen and duplicate it a number of times in the same table as recurring
transactions, each of which would have a different billing date. I have
considered several approaches, but would like some suggestions about how to
proceed.

Thank you.
 
The two alternative ways to add the new records would be:
a) AddNew on the form's RecordsetClone
b) Append query (using a Cartesian product with a counting table to get the
multiple values) and then Requery the form.

The first one would be simpler.

This article gives an example of both:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html
It uses the Recordset approach to duplicate the main form record, and the
Append query approach to duplicate the records in the subform. Since you're
not trying to duplicate related values in a subform, you can just ignore the
second part.
 
Back
Top