[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
>