Select multiple records And export

[badgateway]

Hi all,

I have problem concerning subforms. I have a form with a subform with multiple records. What I want is that you can select one or more records in the subform and that you push a button so that the selected records are dropped in a new table. I'll use that table to create a Word doc with merging. Does anybody have an idea how I can manage this(the dropping into a new table part ;-)?
thanks in advance

 

[kjv1611]

Have you tried using a DAO.recordset? I would think you could transfer the data that way, or possibly more efficiently with SQL code (a query).

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[kjv1611]

Maybe a Make Table Query?

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[badgateway]

Hi guys,

I Know I can(?) do it with a query but how? If I select a bunch of records in a subform and want them with a sql query insert ,the selected rows, into a new table, how in tha name of our lord jesus can i do that ;-)??

thanks for the reply's