Continuous Form Recordset as a basis for report

[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

 

[Sylvain Lafontaine]

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?

 

[Guy]

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

 

[RJ]

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

Thanks for the replies,
RJ