copy form to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top