E
Ernie
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
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