[AccessD] Strange Filter By Form Problem.

Hi Lawrence:

Does forcing a refresh, to the offending combo box object, make the filter
work? Does the selection results of one combo box dictates the results in
another combo box...in similar cases a forced 'refresh' is required.

I tend, not to trust Access automation (...and bound fields for that matter)
as 10 to 15 years ago, the same problems randomly occurred and could only be
resolved completely using direct program control.
   
Jim 

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