[AccessD] trying to filter a form on a control's value

Hi Bill

No, filters are not very tricky. But the filter can only be changed if something tells it so.
So either you will have to use the AfterUpdate event of the other form to reapply the filter, or you can use the OnActivate event of the form to check if the value to filter for has changed on the other form.

/gustav

________________________________________
Fra: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> på vegne af Mark Simms <marksimms at verizon.net>
Sendt: 27. december 2014 17:22
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] trying to filter a form on a control's value

Yes, that toggle is required. Filters are very tricky.

>
> Are you setting the Filter On property too?  I seem to recall needing to
> set filter on to False, setting the filter, and then setting filter on to True.
>
> Charlotte