Lawrence Mrazek
lmrazek at lcm-res.com
Mon May 7 11:36:39 CDT 2012
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 >> > >