MS Access vba

I have a continuous form which can be filtered to show certain records based on the criteria that I input. For example, I can filter the FORM by age, say filter and show me records that have 100 years and the form will show the records based that are 100 years. I need someone to write a a code/script which will append the content of my continuous form into a table by clicking a button on the form. Each time I filter on different criteria, the number of records will be different. I want to be able to press a button on the form that will clear the contents of the table and append the new records that I have filter into the table. I have done it using query and referencing the forms but It only appends the first record and not the other ones. Let me know if you can do it quickly.