[AccessD] Strange Filter By Form Problem.

Is FacID in a bound text box on the form? If so, is the name as well as the
controlsource of the text box FacID?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Monday, May 07, 2012 9:01 AM
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