Going to records in a report

[Guest]

Is it possible to go from a form to the report containing that data for
example entering a customers' order and then wanting to see their invoice
through the click of a button without having to go through all invoices for
all customers.

If anyone knows how to do this, please can you let me know.

 

[Allen Browne]

Sure. See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

The article explains how to put a button on your form, to OpenReport with a
WhereCondition that limits it to just the current record.

 

[Allen Browne]

You can use a WhereCondition with OpenForm as well.

If you are attempting to keep 2 forms in sync, see:
Using Code to Dynamically Synchronize Two Forms
at:
http://support.microsoft.com/kb/210060/en-us