I'm trying to use a make table query to make a table from a parameter query, but Access requests parameters before making the table. My parameter query reads two values in two unbound text boxes on a form. A command button on the form executes code that passes values to the unbound text boxes and then a report reads the results of the parameter query.

I also need to make a table from the parameter query that produced the report as part of this process (without being prompted from input of parameters by Access).

any suggestions?

any example code would be most helpful. Thanks!