copy form to subform

[Guest]

How would i copy all fields in my main form and have the same data in the
subform of this record. And keep on adding records to the subform of that
main record on a button press in the subform?

thanks

 

[Guest]

Why would you want to store the same data in 2 different tables?

 

[John Vinson]

How would i copy all fields in my main form and have the same data in the
subform of this record. And keep on adding records to the subform of that
main record on a button press in the subform?

thanks

Bill's right: this is almost surely NOT something you want to do.

It's typical to have one field (or occasionally two or three) as the
linking fields between the parent table and child table; these can be
used as the Master Link Field and Child Link Field properties of the
subform control. However, storing data redundantly in both tables is
usually neither prudent nor necessary.

John W. Vinson[MVP]