Selecting Report Page

[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

 

[Duane Hookom]

The DoCmd.OpenReport method uses the "Invoices Filter" query which limits
the OrderID to [Forms]![Orders]![OrderID].