How do I view different records using the same report

[Guest]

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

 

[Guest]

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 can change the RecordSource Property. Search help file for RecordSource and
it will tell you how to use change the property. A typical place to change this
is on the reports On Open event, but you can do it anytime you wish.
gm

 

[Mike Painter]

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....

 

[Allen Browne]

Typically you use a form, where the user finds the record they want to
print, and then clicks a command button to print just that record.

Details in:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html