Duplicate a record including subform data

[PortyAL]

Hi

I have a form "frm Risks" to record and evaluate risks. This form includes 3 subforms in datasheet format: "control subform", "causes subform" and "actions subform". The bulk of the data is in the subforms.

I want to be able to duplicate a record including the data in the subforms. (Once duplicated I need to change 1 field, but I can do this manually).

The "Duplicate Record" button wizard only duplicates the data in the main form (frm Risks), but not the data in the subform.

Any advice would be greatly appreciated.

Thanks

AL

 

[Remou]

The simplest way is probably to create a series of append queries.