Find Data in a table from values in a form

[RPW1]

I have a form called "View" that has two Fields "Dealer" and "Acct #" in a database called "schools". Dealer could have multible values and I have tables that correspond to the "dealer" value in the same database, as the dealer field. I would like to create a temporary table from all the records in that table where the "Acct #" is equal to the record on the form. I will use that data for a report designed from the temp table.
Thank you!

 

[Chavito21]

You know you can create a report from a query so you don't have to create a temp table.
Is there any reazon why you want to create a temp table???

 

[RPW1]

I can create this report from a query but I have to select the table for the query from the value on the form. There are 25 tables thatr could correspond to the dealer value on hte for.