[AccessD] Strange Filter By Form Problem.

WAG - try renaming the combo box cboFacID just in case there is some
conflict?

R
 

-----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:37 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Strange Filter By Form Problem.

Another strange thing ... the filter works fine if I hand-code the
interaction via unbound comboboxes.

On Mon, May 7, 2012 at 11:23 AM, Lawrence Mrazek <lmrazek at lcm-res.com>wrote:

> Hi Rocky:
>
> No, they are simply bound comboboxes ... they display the text from 
> the related table, but the ID from the related table is bound. Hmmm 
> ... but the name of the controlsource is the same as the field (EX: 
> field=facid, combobox name= facid).
>
> Could this be an issue?
>
> Thanks!
>
>
> On Mon, May 7, 2012 at 11:16 AM, Rocky Smolin
<rockysmolin at bchacc.com>wrote:
>
>> 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
>>
>> --
>> 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