I have a form with a sub form.  I want to be able to duplicate the record, but with some values left blank / changed (for example, barcode cannot be duplicated) so rather than use the report duplicate I decided to use a button.

I have successfully Created New records with the right fields left blank etc, but no matter what syntax I try to use, I cannot seem to duplicate the sub form rows.  Has anyone done this before and what is the syntax to use?

Thanks