Move a record from a form to a subform??

[stateemk]

I have a form set up with current customer certification on it. The customers take tests and test into different certifications. I need to be able to have the current certification for the customer on the main form, but when a customer tests into a different certification, I need to be able to move some of the old certification data to a history subform and add the new certification data. I have attached an example of what I am needing to do.

[dsatino]

Forms don't store records, they just display them. You really need to supply the underlying sources for the form and the subform before anyone can help you.

[stateemk]

Here's the attachment with the Interpreterstes t table which feeds the form and the Previous Certification table which feeds the subform.