[AccessD] Strange Filter By Form Problem.

Oh, it works...but it only works in the sequence I showed in the example.
Always trace the Form_ApplyFilter event handler to confirm.
It's not intuitive to me as to why "False" triggers the ApplyFilter
event....
It's likely because the prior value was "True".
Bottomline: it fires only when changed !
But it fires ONLY when going from True to False.
That's why the new filter value must be set BEFORE that occurs (see example)
Go figure.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
> Sent: Monday, May 07, 2012 2:46 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Strange Filter By Form Problem.
>
> Yes, i've toggled, untoggled the filter ... occassionally it worked,
> which
> isn't quite good enough! I'm just going to build my own filtering
> options
> ... they'll work better.
>
> Thanks!
>
> Larry
>
> On Mon, May 7, 2012 at 1:23 PM, Mark Simms <marksimms at verizon.net>
> wrote:
>
> > Did you try to toggle the Filter when it was changed:
> > Me.Filter="[table].[facID] = 2"
> > Me.FilterOn = False ' Fires the Form's ApplyFilter Event handler
> > Me.FilterOn = True ' Fires the Form's Current Event Handler
> >
> > This is very touchy in AC2010.
> >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> > > bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
> > > Sent: Monday, May 07, 2012 12:01 PM
> > > To: Access Developers discussion and problem solving
> > > Subject: [AccessD] Strange Filter By Form Problem.
> > >
> > > Hi Folks:
> > >
> > > We have a couple of users that like to use the built-in filter by
> form
> > > functionality in Access 2007.
> > >
> > > We have a form that has a 3 combo boxes on it, plus a number of
> > > textboxes
> > > and a subform.
> > >
> > > If the user does a filter-by-form and chooses only one of the
> > > comboboxes,
> > > the filter works fine. However, if you try to filter multiple combo
> > > boxes,
> > > the system throws an error message saying the "The Microsoft Office
> > > Access
> > > database engine does not recognize "FacID" as a valid field name or
> > > expression". (FacID) is on the main form's recordsource.
> > >
> > > Has anyone seen this sort of behavior?
> > >
> > > Thanks in advance.
> > >
> > > Larry Mrazek
> > > lmrazek at lmrazek@lcm-res.com
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com