Copy values of Main and Subform (only main form working)

[vbaInet]

Of the 40-50 fields how many of them are in your subform?

And I'm just looking at your form, it looks like you've got the logic all wrong. The checkbox just indicates that the old values should be copied across, it doesn't say dictate that when clicked a new record should be created and records copied across.

The code should have gone in the Brand New button's click event. Anyway, I'll look into it in a short while.

 

[Heatshiver]

The 40-50 are for the subform. The main form will always have those few items. There will be some forms with multiple subforms. Originally there were no subforms and the checkbox would just copy everything on the main form to a new record with the runcommands. However, I needed to normalize everything and this brought subforms into play.

Thank you for looking into this. I really just want to get through this!