Insert into a table a copied portion of a table

[Bill]

Hi,
I have a form with a subform in a parent child realtion.
Such that each record of the subform has an identifying ID which links back
to the ID of the main form.

I can filter out subform values using the this ID number

So that these values (say 30 lines) can be copied into a new form and
entered in that subform but with that new forms ID - can this be done with
insert into and if so how?

I have an idea of taking the filtered query and creating a temporay table
which can be used to insert back into the subforms table - not sure if this
correct or how to do it.

How can I copy part a subforms recorset back into the subforms table but
with the new ID showing for each copied entry?

Hope someone can help.
Tahnks in advance
Bill

 

[Doug Robbins - Word MVP]

If this question pertains to Access, you should post it to one of the Access
newsgroups.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Bill]

Yip your right.
Sorry This is what happens when there is a lag between signing in and
finding out now it reverted to the wrong group on refresh.
Sorry.