Import subform filter to table

[RJN]

Import subform filter results to table

I have a form with some combo's and subforms that are filtered based on combo selections. I want to import a filtered record set into a table. I have an export button with events. I can't seem to find a method that is suitable for working with this record set.

Is there a method to grab the subforms filtered record set and export them to a table?

Is there a method to grab the subforms current record from the filtered record set and loop until all rows in record set have been exported?

Thanks