Insert into

[coolcatkelso]

Hiya

Access 2007

Can I use the INSERT INTO command to copy a record from one subform to another subform on a differnt record?

Want to copy the Entire form and subform to another form and subform?
________
Weed Vaporizers

 

[ezfriend]

I think what you want to do is to copy the current record on form/subform A to form/subform B by inserting into tables instead of forms. You and I probably agree that the form is use for displaying/editing purpose.

If the tables are identical, you can detect what's current on the form/subform and using that record id, you can actually perform an INSERT INTO (table-to-table)

Becareful when you insert sub records. Make sure you get the correct parent record id.

 

[coolcatkelso]

Cheers for the reply

Any ideas on how I do this tho?
________
Zoloft settlements