I was trying to filter records from a combo box in a form, I received an error message said “Type Mismatch in Expression”. It means a join expression is attempting to join the two tables on fields of incompatible data types, according to Microsoft Access Help.
I checked the data type in the Lookup table for the combo box. There are two fields in the table, one is autonum and the other is text.
Here is how I set up the properties for combo box in the form:
Row Source- tblLookup
Column count – 2
Column widths – 0”;2”
Bound column – 1
It stores the values in column 1 but displays the values in column 2.