print one record of a form using a report

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

I want to print the current record of an open form using a report. I assume
this can be done by adding a print control button on the form, but how do I
specify to print this one record?

Best,
Christopher
 
Christopher,
Your form should have some key value, such as a CustomerID or a
ProductID...etc. Thta's the field that "identifies" this record as opposed
to all others.
In the query behind your report, use the value from your open form to
"filter" the records returned by the report query.
Using the example of CustomerID... in the report query, in the CustomerID
field, place this criteria... (use your own names)
= Forms!frmYourOpenForm!CustomerID
When the report runs, only the record that has a matching CustomerID will
print.
hth
Al Camp
 
Back
Top