Loading a Filter with a report Using the Form's Filter Property Line Item

[catbeasy]

I'm using Access 97 and was trying to put a filter clause in a reports Filter property.

I tried typing:

="PROD_TYPE = 'SEL'"

and setting the Filter On property to Y.

This didn't work. Help shows how to do this in visual basic, but doesn't show anything about how to use the Report's Filter property..

Any help on how to use the Report Filter property is appreciated..

Thanks..

 

[HiTechCoach]

Are you doing this in VBA code? If yes, can you post all the VBA code ypu re using for the event?

 

[catbeasy]

Are you doing this in VBA code? If yes, can you post all the VBA code ypu re using for the event?

No, I am not doing this in code. I am trying to use the Filter property of the report.

I open the report in design view and then click view->properties and then the Properties Dialog box comes up. I click on the All tab and the 2nd entry in the properties is Filter. In that field space, I was trying to add a filter clause. An SQL "where" clause without the where (as help puts it).

That is where I want to put the filter, not in visual basic code. Help doesn't make it clear how to do this though. When I put my cursor in the Filter property field and hit F1, the help shows an entry that is visual basic code as:

Me.Filter = "Country = 'USA'"
Me.FilterOn = True

It also says:

You can set this property by using a table's or form's property sheet, a macro, or Visual Basic.

It doesn't mention Reports. Is that because you must use VB to set the Filter. If so, then what is the Filter property for in the report Properties Dialog Box? What kind of entry does it take.

Kinda confusing..

Thanks for any continued assistance..