Type mismatch in expression

[jh3016]

I'm getting an error message in my main form that has a subform attached to it. I have no idea how to even start to find out what the problem is. Any ideas?

 

[sunshine19]

Do you have an IIF statement or sql statement in your form? If so, check these types of things to see if you have quotes around numeric data types or no quotes around text, etc.

 

[jh3016]

Thanks for quick response. I don't have IIf statement. It's just a simple main form and subform linked together by the "Employee" field.

 

[Kherozen]

check in the table if the 2 employee fields are of the same type


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.