Navigating to a report from a form (invoice)

[Guest]

I am trying to build an invoice report that I can navigate to directly from
an orders form (with subform). I am using a highly modified Orders entry db
template. I need to filter the report so that it only shows the invoice of
the order I navigated from. Is that possible? It seems like it should be -
but I can't seem to get it!
Any help is awesome!

 

[Nikos Yannacopoulos]

Assuming:

1. There is a PK field in your Orders (header) table, something like
InvoiceID
2. Field InvoiceID is bound to a control called txtInvID
3. The form itself is called frmInvoice

I suppose the report is based on a query joining the order header and order
line items tables; modify the query to add the following criterion on field
InvoiceID:

Forms![frmInvoice]![txtInvID]

(change the names to the actual form and control name).

The effect of this is that the report's recordsource will be filtered on the
invoice ID currently on the form (which has to be open when the report is
run).

HTH,
Nikos