ACC2000: "Type Mismatch in Join expression" with Filter By Form (202269)

MORE INFORMATION

Steps to Reproduce Problem

1. In a new database, create a new table called Table1 with the following properties:

      Table: Table1
      --------------------
      Field Name: Id
         Data Type: Number
   
      Field Name: Name
         Data Type: Text
   					

2. Open the Table1 table in Datasheet view and, when prompted to save, click Yes. When prompted about the primary key, click No.
3. Add the following records to Table1:

      Id        Name
      ---------------
   
      10001     Apples
      10002     Pears
      10003     Oranges
   					

4. Create another table called Table2 with the following properties:

      Table: Table2
      ---------------------
      Field Name: Test
         Data Type: Text
   					

5. On the Lookup tab, change the following properties:

      Display Control - Combo Box
      Row Source Type - Table/Query
      Row Source - Table1
      Bound Column - 1
      Column Count - 2
      Column Heads - No
      Column Widths - 0";1"
   					

6. Save and close the Table2 table and, when prompted to create a Primary Key, click No.
7. Use the Form Wizard to create a new form based on the Table2 table and add the Test Field.
8. Click Finish.
9. On the View menu, click Form View.
10. On the Records menu, point to Filter, and then click Filter By Form.
11. Select one of the names from the combo box for Test.
12. On the Filter menu, click Apply Filter/Sort.
    
    Note that you receive the error message described in the "Symptoms" section. In this case, switching to Design view in the Table2 table and changing the Test data type to Number resolves the problem.