Fuzz:
Only in Access 2002 can you set a report's recordsource to be a recordset;
and in doing so there are serious drawbacks, i.e. that you can't group or
sort the data or use headers/footers etc. otherwise the report fails.
One might think you could open the recordset in code and simply loop through
it setting unbound controls to use its values. The problem is that Access
reports require some "source" to force the output of detail rows. So total
disconnected sets don't work at all.
Another alternative you might try if you have a significant disconnected
set, is to write it out to a file; attach it and then use that as the
recordsource.
