Mazzaxe said:
How do I display a single record on a report and then use the same
report to display a different reord set. Surely you don't have to
create a new report for every entry if the report format is the
same???
Any help gratefully received
You don't have to but I frequently do. I'm lazy.
Cutting and pasting, then changing the recordsource can be a lot faster
than writing the code required for what you want.
Frequently Text has to be changed to indicate what you are seeing,etc.
One report would be based on a query with Forms!YourFormName!YourKeyField as
the source for the single report. The other would be with the other
recordset.
If you don't do it this way you have to build SQL queries in code then use
them to open the report.
The Access developers Handbook has some excellent examples of what you are
asking about. It belongs on everybody's shelf.
Of course it does raise the question of why we buy expensive books so we can
bill our clients for less hours....
