Presenting form information

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

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.
 
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
Click to expand...
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
Click to expand...
and only shows the Customer selected on the form.

Hope this helps!

Howard Brody
 
Back
Top