clear a filter on close

  • Thread starter Thread starter johnlute
  • Start date Start date
J

johnlute

I have a report that filters based on form controls. It works as
desired however when the report is run again and the form controls are
left blank (as desired to return all records) the report returns what
it was previously filtered for.

Is there a way to clear the filter on closing the report? I've
searched around but can't find any examples.

Thanks!
 
Thanks, Gina and Allen!

I'm using 2003 which has the Filter On Load property. I was actually
going to try it but thought it was required to filter the report in
the first place. Anyway, I set it to No and it behaved as expected.

Thanks!
 
Glad to help!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks, Gina and Allen!

I'm using 2003 which has the Filter On Load property. I was actually
going to try it but thought it was required to filter the report in
the first place. Anyway, I set it to No and it behaved as expected.

Thanks!
 
Back
Top