Temparary SQL table passed to a report

[mpfohl]

I created a search form that builds the Search SQL depending on what
the user selected

it takes the results of that search and dumps it into a table I
created called "SearchTable", if there is already data in that table,
it just overwrites it.

the only thing it is dumping into that table is a list of ID numbers

I have a report that then opens and produces a report based on those
ID keys

so i basically want to take out that middle man of having a static
table and have the search create the list of ID's and hold in in the
code, then some how pass that to the report

that way, multiple users can run searches at the same time

as it is, only one user can run a search at a time since there is just
one static search table.

how do I do this?

 

[Roger Carlson]

Why do you have to create a table? Can't you just build a query in code and
use that as the RecordSource for the Report?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[mpfohl]

I would like the results of the search to be shown on the search form
first for the user to scroll through. If that is the result list the
user wants, they click a 'print' button and then the report pops up.
So i'm not sure how to have the results be posted in a form and a
report without having some table involved. Am I missing something?

 

[Roger Carlson]

A query (which is actually a view into another table or tables) can also be
the Control Source for a form or report. Therefore, you shouldn't have to
create a separate table to house the results.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L