Parameter query run before report query

S

SMJ

I have a query that is the basis of almost all reports.
This query has to have date parameters sent to it before
the query for the report is run. How can I sent the date
parameter from different forms (to run different reports)
to the same query.
 
M

MacDermott

One work-around would be to keep your base form open, but hidden.
When you go to run a report (e.g. in the OnClick procedure of a button),
first copy the relevant data to the hidden form.

HTH
- Turtle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top