Copy data from form to table

[primagic]

I have a subform (datasheet view) that is a list of records. What I want to be able to do, is copy all the records in that form to a table.

So for example,

I want to take:

Customer ID from the subform and insert the reecords from tblCampaignHistory. I also want to take the current campaignId from the parent form and insert that into the same table. This campaignid will be the same for all the records added above.

Do I have to use insert into or something similar?

 

[randy700]

You probably just need to run an append query.
Where is the data located now?


Randy

 

[ProgramError]

How was the list of records created? a query, table, input bu the user?


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.