Filter not working on Report

[NWTrust]

Hi
I need to display selected entries on a form and also a report. The selection is in a variable called gstrTester. The call to the form is: DoCmd.OpenForm FormName:="frmSelected", WhereCondition:=gstrTester. The contents of gstrTester appear in the form's Property Sheet Filter box and the form appears correctly.

The same does not happen with the report. The call DoCmd.OpenReport "rptSelected", WhereCondition:=gstrTester does not fill the report filter box and so the complete table is printed, not just the selected entries.

Can someone please tell me what I'm doing wrong?

NWTrust

 

[dhookom]

Is gstrTester just a simple string or a boolean equation? I would think you need to use something like:

DoCmd.OpenReport "rptSelected", WhereCondition:="[SomeFieldName]=""" & gstrTester & """"

Duane
Hook'D on Access
MS Access MVP

 

[NWTrust]

gstrTester is a string containing a field name and a name within the field.

 

[NWTrust]

Sorry, I should have been a bit more specific. gstrTester contains: [field name] = "word(s) to search for

 

[dhookom]

It would have been helpfull if you had provided some exact contents of gstrTester.

To help trouble-shoot, add a text box in the Report Header section with a control source of:

=[Filter]

Duane
Hook'D on Access
MS Access MVP

 

[NWTrust]

An example of the contents of gstrTester is [Parish] = "Drayton]" to list all entries where the Parish is Drayton. As I stated originally this works perfectly in a form but not a report.

I'm not sure what you mean about adding a text box.

 

[dhookom]

In your report design view, select the text box control from the Toolbox and add it to your report header section. Then just set its control source property as suggested.


Duane
Hook'D on Access
MS Access MVP

 

[NWTrust]

Thanks for your time dhookom. I have been 'fiddling' and somehow have solved the problem (I'm not sure how but I don't feel inclined to find out!). Thanks again.