Duplicating a record

[integritycare]

Hello,

I have a been requested to implement a way in which an invoice can be duplicated so that dates can be changed on the subform without having to reenter all the data
The mainform has a subform which holds the invoice items.
I put a duplicate control on the mainform which will duplicate the mainform , but how can I get the data from the subform to copy all the records, so that the invoice is an exact copy.
The subform is linked to the mainform by invoice number.

Many thanks,

Integrity

 

[dhookom]

This is a basic append query involving the record source of the subform. If you provide some significant table and field names, I expect someone can help with the code.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

copy all the records, so that the invoice is an exact copy" - cannot be.
I hope you have some Primary Keys on your table(s) (if not, you should) and they canNOT be duplicated.

Have fun.

---- Andy

 

[missinglinq]

Allen Browne has a hack for copying the Records in Main Form and Subform:

http://allenbrowne.com/ser-57.html

The Missinglinq

Richmond, Virginia

The Devil's in the Details!