Saving data from query to another table

[Irfan Khan]

Hi all,

Requirement : I have two tables. In first table I have some data which is already stored. And now I have created one form for search data from that existing data table, when result found   I wanted to store that data to another table, can any one pls guide my easy way to overcome. 

Thank you in advance