How can I produce a report for a single record of a table

[Allen Browne]

Simplest approach is to use a form where you choose the record you want to
report on. Place a command button on the form to print just that one record.

It works like this:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html