Printing Report Criteria in Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is a brief description of what I am working with and what is going on.
Thanks to any of you that can help...

I am attempting to run a parameter query off of a form with combo moxes that
are created from tables so that the list constantly updates to the data. In
my reports I would like to reference what was selected to limit the query.
The problem I am having is when I reference let's say
[Forms]![frmReport]![combo box goes here] the reports show what is stored in
the primary table and does not print the entire "name of the object"

When I switch to a different bound column then the report yields no results,
I am guessing b/c the query is searching for the entire (program name)
instead of the autonumber in that field.

Again thanks.
 
Ex. If you were referring to a combo where you select a Customer Name
(cboCustomerName)
Then, using concatenation on your report, a field with a ControlSource of...
= "Customer = " & Forms!frmReport!cboCustomerName
would display as...
Customer = Dewey Cheatum & Howe
hth
Al Camp
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Header displaying incorrect information 2
Date in the text format. 2
Assigning print date / batch number to reports & invoices 6
Unusual Calculation in Report Header 1
strWhere criteria 1
Access Access Report Works on One Machine but not Another 3
Missing Report Header 1
Having user define a report criteria 1

Back
Top