I want to either duplicate the previous row that has been populated in a subform or better still copy some of the fields using code.

Any ideas? Is this possible?