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
 
Back
Top