copying records within subforms

[T Best]

Hi all,

I have a form with several subforms. With a click of a button i want to copy
the main
record and all data in the subforms that is linked to the main record.

what is the easiest way to do this?

TIA
Ted

 

[Larry Linson]

Copy to where?

If the user can, and has, made changes to the information, do you want the
changes saved to the new location, and, also, do you want the changes saved
to the original location, too?

If there are multiple related records displayed in the Subform Controls, do
you want them all saved, but with a Foreign Key to the main Record in its
New Location?

The "generic answer" is, you will need to accomplish this using VBA code in
the Click event of the Command Button.

Larry Linson
Microsoft Access MVP