Save current form data to another table

[Alan Holroyd via AccessMonster.com]

Hi,

I have a table which is a linked excel table. I have created a form to
search through the data and display the required fields. I need to then
save the displayed information to another table using an event procedure
triggered by a button click.

Any help would be appreciated.