Type mismatch in expression. (Error 3615

[dwaynesworld013]

I receive the following error whenever I try to open one of my tables in
Access:
--Type mismatch in expression. (Error 3615)
Does anyone know how to fix this? I made sure that all of my joined fields
match. It is preventing me from opening my table in datasheet view.
Thanks for your help.

 

[Douglas J. Steele]

I don't understand what you mean by "open one of my tables" and making "sure
that all of my joined fields match".

If you're opening a table, there aren't any joined fields. If you're trying
to open a query that joins two tables, what's the query?

 

[KARL DEWEY]

Narrow down the problem by trying to run the query alone that is the record
source for the form.
Any calculated textboxes in the form?

 

[dwaynesworld013]

To Douglas:
I was trying to open my table in the datasheet view but am unable to. I get
the Type mismatch error message just whenever I try to view the datasheet for
the table (I can open in design view)

To Karl:
The query linked to the table runs just fine. I do not have any calculated
text boxes in the form that feeds into the table. This started after I
changed the criteria from one of the fields in the query from Group By to
SUM. After receiving the error, I changed the query back to the original way
that it was but am still receiving the error. The help received from Access
stated the following:

Type mismatch in JOIN expression. (Error 3615)
A JOIN expression is attempting to join two tables on fields of incompatible
data types. For example, you will get this error if you attempt to join a
Memo field with a Text field.

 

[Douglas J. Steele]

Are you using Lookup fields in your table? Did you change the definition of
the table which your current table is looking up its values in?