report based on filter query recordset

  • Thread starter Thread starter dick
  • Start date Start date
D

dick

How do I base a report, say "jones_rpt", on the current
record set of a filter by query? Examples of the code
behind a button on the form would be appreciarted. Maybe
my Q is same as "what is the name of the record set of the
current instance of the filter by query"?

Thanks, Dick.
 
What you need to do is build the form that asks for the
criteria, link the info to a query or multiple queries and
in the report_open event of the "jones_rpt" use the
criteria on the form to run the appropriate query. Sorry
if this isn't the answer you wanted but there is no
current instance until the query is run and if the query
is run outside the report then it isn't usable by the
report. The report must run the query and manipulate the
incoming data. The code behind the button isn't really the
important code. The code in the report_open event is more
critical. The Developers Solution sample is pretty good at
showing you what to do. In many cases you can copy a lot
of the code right out of the sample and use it in your
form and report.
 
Back
Top