subquery with in clause in MS Access.

i used below query in MS Access but it's not working.
select * from Course where CStr(CourseCode )  in  (select applicablecode from Course where CourseCode = 14)
but it returns only null value.. 


where applicablecode = Text datatype  &   CourseCode =  Number datatype