control Source ?

  • Thread starter Thread starter Pat Coleman
  • Start date Start date
P

Pat Coleman

I have a basic report that shows Customer info from the CUSTOMER table.
The report shows specific cust info, one customer per page.

I want an option, before the report is executed, to allow me only to return
results from customers who's TYPE field = "Wholesale"

I have a feeling I can put an expression in the control source field in the
properties of a text box in the header of the report that will just return
the customers I need.

I have tried a few expressions but my syntax is very rusty and I get errors.


( I am not 'allowed' to pull this info from a query ) - dont ask !!

Any Pointers ???
 
Pat said:
I have a basic report that shows Customer info from the CUSTOMER table.
The report shows specific cust info, one customer per page.

I want an option, before the report is executed, to allow me only to return
results from customers who's TYPE field = "Wholesale"

I have a feeling I can put an expression in the control source field in the
properties of a text box in the header of the report that will just return
the customers I need.

I have tried a few expressions but my syntax is very rusty and I get errors.

( I am not 'allowed' to pull this info from a query ) - dont ask !!
Click to expand...


The standard way to do this is to use a form with a button
that opens the report. You can then use the OpenReport
method's WhereCondition argument to filter the report:

DoCmd.OpenReport "ReportName", , ,"[Type] = 'Wholesale' "
 
Back
Top