printing a form to report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have all my forms and reprots complete and am now adding commands. The
command that i am having trouble with is the print. I want the form that i am
working on to print onto the report that i created for it.
IE: in the Northwind database the order is filled in and when print invoice
is selected it prints the invoice for only that record. Now when i do that it
prints all the report pages.
What do I need to do to tell it to print only a specific order?
 
Jenn,
Each record displayed on your form should have a unique "key" field
identifier, such as a CustomerID, or PONo, etc... that is associated only
with that one record. Let's say, as an example, it's CustID.
You'll place a button on your form to run the report. (ex. "Print This
Record")

In the query behind your report you would place the following criteria
against the CustID field...
= Forms!frmYourFormName!CustID
This tells the report to only return the one record from your table where
the CustID is equal to the CustID currently displayed on the form.

You'll leave the form open while you Preview/Print the report, and upon
closing the report, you'll return back to the form.
 
Back
Top