Im creating a master manufacturing record. Once that form is filled it & saved I need to create a batch production record based on that info from the MMR each time I make a production run. The MMR includes a subform that is built while completing the MMR. For example it includes mfg steps. Some MMRs will have 5 steps while others have 12. This subform is built using the add new option to certain fields. The BPR will have a bit more info than the MMR so I will need to copy the data into it.

I posted a question earlier about how to use the fetch code from with the BPR to recv data from the suform .It was not answered so I came up with another idea.

Is it possible to have a check box on the MMR that says create BPR.

When checked & updated it will created a new form with all the data....

Thanks