Data type mismatch error

[megabyte214]

I am gettting this error:
Data type mismatch in criteria expression
The primary field typeID in the courseType table is an integer
I am linking to typeID in the course table which is also an integer...!!!

My SQL statement:

intcoursetypeID = "11"
strSQL2 = "Select courseType.typeID, course.course, course.courseID FROM courseType INNER JOIN course ON courseType.typeID = course.typeID WHERE courseType.typeID = '" & intcoursetypeID & "' "

 

[durug]

try
WHERE courseType.typeID = " & Cint(intcoursetypeID) & "

delete the single quotes and put the Cint in front of intcoursetypeID

It will work for sure.
Regards,
Durug I was born intelligent - education ruined me.

 

[megabyte214]

Thanks, it worked!