How do I Move data from a Form to a Table?

  • Thread starter Thread starter Brian Cummings
  • Start date Start date
B

Brian Cummings

The Goal

I have a project that requires many charts be generated
out of a single pool of data. I will need to be able to
dynamically change the filters and make new charts.

The Issue

I have a form with a set of fields that I can apply the
filters to, but once I have applied the filters, I don't
know how to get the filtered data into another table.
What I want to do is the equivilent of selecting all the
records after filtering, and cutting and pasting the
filtered records into another table. How do I do this
programmatically? Any help would be greatly appreciated.
 
create a make table query and use the filter property of the form as the
where clause of the query. If you need example or clarification just reply
to group.
HTH
 
Back
Top