ACC95: Filter By Form Fails in Combo Box Filled with Value List

MORE INFORMATION

In Filter By Form mode, Microsoft Access treats the displayed field as the bound field, and then places the restriction on the looked-up value for the table or query that the combo box is filled from. This technique cannot be used for combo boxes filled with a value list.

Steps to Reproduce Problem

1. Open the sample database Northwind.mdb and add the following new field to the Employees table:
   

         Field Name: Gender
            Data Type: Text
            Field Size: 1
            Display Control: combo box
            RowSourceType: Value List
            RowSource: Male;M;Female;F
            BoundColumn: 2
            ColumnCount: 2
            ColumnWidths: ;0
            ListRows: 2
   						

2. Save the changes and view the Employees table in Datasheet view.
3. Click Male or Female for the new Gender field for each Employee record.
4. Click the Filter By Form toolbar button, click "Male" in the combo box for the Gender field, and click the Apply Filter toolbar button. Note that no records are returned.
5. Click the Remove Filter toolbar button.
6. Highlight "Male" in the Gender field for an exiting record and click the Filter By Selection toolbar button. Note that records with Male selected are returned.