duplicating records in parent and subform

[Jason Tarewicz]

I am trying to duplicate a record that resides in a parent form. I can accomplish this will VBA code. However this is also a sub form involved that is linked on a job #. I also need to duplicate all the records in the subform. When i duplicate the parent form, the subform remains blank. I need to duplicate the subform with the same records but tie them to the new job# that is created when I duplicate the parent form

For example
parent form data:
job#: 12
style#: loos
subform data
job#: 12
edges:
size: 5

REPLICATE
parent form data
job#: 45
style: loos
subform data
job#: 45
edges:
size:

ANY SUGGESTIONS??? Thanks in advance