[AccessD] Strange Filter By Form Problem.

Lawrence Mrazek lmrazek at lcm-res.com
Mon May 7 12:46:02 CDT 2012


Agreed ... I'm manually adding the filter to this form ... it was just a
simple filter ... should have worked fine.

Thanks for your help and feedback ... I needed some confirmation that I
hadn't over-looked something really obvious.

On Mon, May 7, 2012 at 12:01 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list