Presenting form information

[Jeremy]

I have a dtabsae which uses a multi-table form. I want to
present the information from one record in a customer
facing document. Can I do this using a report?

if I create a report to present the field information
from a record I get ALL the reords in the database
whereas I just want one record at any one time.

 

[Howard Brody]

You can run your report for just the selected customer one
of a couple of ways but both entail selecting the customer

In the source query for the report, set the criteria for

the Customer field only to pull the customer listed on the
form (put: "[Forms]![frmFormName]![CustomerControlName]"
on the criteria line under the Customer field in the Query
DesignView.

Put code behind the report so when it opens it filters

and only shows the Customer selected on the form.

Hope this helps!

Howard Brody