Generating Individual Records in a Report

I have a user that needs the ability to print individual records from a
table. What I have now is just a form, and to print by an individual record
I showed the user how to filter the record(s) they need. The form gets the
job done but will sometimes give an extra page when it prints, and also has
my command buttons on the printout. I would like to get rid of that and have
a report instead to generate the record(s) needed. However, I am completely
stumped on how to give the user the ability to make the report print only the
records the user specifies and how to format the report to display only one
record per page. I'm sure this is basic for most so excuse my simplistic
question. Any help or suggestions would be greatly appreciated.

TIA,
-Paul

Forms are for viewing, reports are for printing.

Create a report with a layout similar to your form and in
the control which you use to print, add to the 'OnClick'
event a line similar to:

DoCmd.OpenReport YourReportName, _
acViewPreview, , "[MainFilterField] like '" & Forms! _
frmFormName![MainFilterField] & "'"

basically you are adding the filter that you used to
select the record for your form to the report for
printing. If this record takes two pages (or more) that's
another problem, but the above should get you just one
record on your report.

The above assumes that your filter control is text, if it
is numeric, drop the single quotes (') as well as the
trailing & "'"

YourReportName should be whatever you called your report
(don't use the same name as your form)
MainFilterField is the name of the column that you are
using to filter on your form.

HTH
-----Original Message-----
I have a user that needs the ability to print individual
records from a
table. What I have now is just a form, and to print by
an individual record
I showed the user how to filter the record(s) they need.
The form gets the
job done but will sometimes give an extra page when it
prints, and also has
my command buttons on the printout. I would like to get
rid of that and have
a report instead to generate the record(s) needed.
However, I am completely
stumped on how to give the user the ability to make the
report print only the
records the user specifies and how to format the report
to display only one
record per page. I'm sure this is basic for most so
excuse my simplistic
question. Any help or suggestions would be greatly
appreciated.

TIA,
-Paul
.