Article ID: 287709 - View products that this article applies to.
This article was previously published under Q287709
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2000 version of this article, see 202269
When you use a combo box or a list box to perform a Filter By Form, you may receive one of the following error messages:
Type mismatch in expression.
Type mismatch in JOIN expression
Microsoft Access didn't apply the filter.
Microsoft Access may not be able to apply the filter if you entered an invalid data type in one of the fields.
Do you want to close the filter anyway?
If you click Yes, Microsoft Access will build the filter, but won't apply it to the recordset.
Then it will close the Filter By Form window.
The control is bound to a field with a different data type than the bound column in the row source of the Lookup field. If the combo box or list box has a value assigned to its ControlSource property, it should be of the same data type as the fields populating the list.
Change the data type of either the control source or the bound column of the Lookup field to match the correct fields.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce the Behavior
For more information about Filter By Form, click Microsoft Access Help on the Help menu, type about filters in the Office Assistant or the Answer Wizard, and then click Search to view the "About Filters" topic.
For more information about Lookup fields, click Microsoft Access Help on the Help menu, type lookup fields in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.