Printing Single Page of Report

[Colin]

Hi,
I have created a database with two tables, Customers
and Jobs.

With a single form with a subform, to enter the details -
Customers is the form, and Jobs is the sub-form.

I have also created a report where the deatils of the job
and customer are combined into one page to print out as
an invoice.

The problem is that the report brings up every invoice in
the database. I only ever want one at a time.

Can someone explain to me how the button on the Northwind
example, in the Orders form works? - the Print Invoice
button. It somehow only opens the report for the order
being viewed and prints that invoice only.

Any help is appreciated, I have maanged to put a button
on the Jobs form which when I click it it prints out all
the invoices but I want to make it so that it will only
print out the invocie for the job being viewed.

Thanks

Colin

 

[Nelson]

You do that by setting the report's filter property as you open it from the
command button. The command button creation wizard should walk you through
it. Also type "OpenReport Action" in the Access help index for more
information. The where condition argument will read "Report'sCustomerID = "
& Form'sCustomerID (with the quotations but using the field names you are
using in the form and report). You can also look at the code behind the
button in the Northwind database by double clicking on on click property for
the button.

Hope that gets you started.