I have created several tables of information. The main table has drop down fields that are linked to the other tables. Everything works great until I want to run a query based on any of the fields in the main table that are drop down fields. I get the error message "Data type mismatch in criteria expression". This only happens if the field in the criteria field of the query is a drop down in the main table.
Any thoughts how I can fix this would be greatly appreciated.