Hi. I have a Search form that once I hit search, it opens a report based on the whereclause:
DoCmd.OpenReport "rptStrat", acViewPreview, , Whereclause
The main report has an underlying query called HEADER, and the subreport has an underlying query called GEO.
This works fine. However I want to add a middle step that adds the selected records to 2 tables. (so I can append multiple searches and so i can view the data first in a datasheet format). One table for header information, and one table for GEO information. Then once the records are in a table format, I can open the report. Thank you for any ideas.