Loop through SubForm recordSet

[aron.ridgway]

Is there a way of looping through a non update able continuous subform, and using information from each line.

Which creates a new record in another table? so if there are 3 records in the subform it creates 3 new records in the other table and so on?

thanks!

 

[namliam]

a simple append query perhaps?

 

[aron.ridgway]

can you use an append query to loop through all the data on a continuous form?

 

[namliam]

not exactly loop through, but to pick up and replicate them all certainly.

Questions arise to the need and reason behind duplicating records/data, but that is another discussion.