control Source ?

[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 ???

 

[Marshall Barton]

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 !!

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' "