[AccessD] Strange Filter By Form Problem.

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