Access 2010 Filter By Form Forces Default Values into filter
Posted on 2011-09-14
I have an access 2003 form that works fine in 2003/2007. When I use filter by form in 2010 the default values from the Combo Box populate the filter fields and I can't get rid of them. For example I have a combo box cbState with "CO" as the default. If I use filter by form to filter on last name of "Smith" it forces the state = "CO" so all I get are "Smith" in "CO" - not all "Smith". This form works fine in 2003.