filter sticking

[GBA]

Access02

Have report sourced on query.

I limit the report records by dynamically building the Where statement for
the Open command depending on selections in an open form.

Works fine.

But sometimes that filter won't clear out of the Report. I have to manually
put the Report in design mode and blank out the old filter.

Otherwise no matter what is the new Where statement it is always opening to
the old data.

Haven't been able to determine a fixed cause/point where this occurs...has
happened twice in a few days...but not regularly...

Anyone seen this before?...and is there a way I can make this clearing out
occur as part of an event, such as Report close - just to be sure it always
starts from a blank slate?

tia.

 

[Duane Hookom]

Every time you open the report with a Where Condition, it should replace the
filter property. You can bind a text box with a control source of:
=[filter]
to see the current Where Condition or Filter.

If you go to design view after opening the report with a Where Condition and
then save the report, it may save the Filter property.

 

[GBA]

indeed - I believe it is as you hint...when I have gone into design view the
where condition then sticks permanent...

much thanks..

Every time you open the report with a Where Condition, it should replace the
filter property. You can bind a text box with a control source of:
=[filter]
to see the current Where Condition or Filter.

If you go to design view after opening the report with a Where Condition and
then save the report, it may save the Filter property.

--
Duane Hookom
Microsoft Access MVP

Access02

Have report sourced on query.

I limit the report records by dynamically building the Where statement for
the Open command depending on selections in an open form.

Works fine.

But sometimes that filter won't clear out of the Report. I have to manually
put the Report in design mode and blank out the old filter.

Otherwise no matter what is the new Where statement it is always opening to
the old data.

Haven't been able to determine a fixed cause/point where this occurs...has
happened twice in a few days...but not regularly...

Anyone seen this before?...and is there a way I can make this clearing out
occur as part of an event, such as Report close - just to be sure it always
starts from a blank slate?

tia.