Continuous Form Recordset as a basis for report

  • Thread starter Thread starter RJ
  • Start date Start date
R

RJ

I have a rather complex inquiry screen that calls a dynamic sql sp to return
qualifying records to a continuous form. What I would like to do is to offer
a the users a way to get a report of the resulting set. To offer it here to
the users means that they don’t have to go to a report options screen, enter
the same criteria etc.

In my SP I could write out qualifying records to a table and then use that
table as my source for the report. Is there a better alternative? Output to
XML? Some great feature of Access / VBA I am unaware of?

Any thoughts?
RJ
 
Why don't you create a report that will query the form in its OnOpen event
for the parameters or the query string to use as its source?
 
In addition to Sylvain's excellent thought, and the following may not work as
I have never tried it...

You could try binding the report in the Open_Event to the form recordset as
in:

Set Me.Recordset = Forms!FormName.Recordset

Guy
 
Both good thoughts. I will work on this today and post any interesting
findings!

Thanks for the replies,
RJ
 
Back
Top