Filter Within Form

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi,

Is it possible for me to filter a particular form with
some conditions of my own??
I managed to find this "Filter With:" when i right click
on one of the records of the field which i want to filter.
The filter works the way i wanted. However, after closing
the form and re-opening it, the filter is gone! So how can
i make the filter condition stay??

Thanks!
 
To reapply the same filter next time the form is opened, you would need to
save the Filter property, and then reassign it (and set FilterOn to True) in
the Open event of your form.

There is an example of how to build a table to store this kind of then
between sessions in this link:
http://allenbrowne.com/ser-18.html

If you always want the form filtered, it would be easier to build a query,
put the criteria in there, and use it as the RecordSource of the form.
 
Back
Top