>SELECT *FROM mytable WHERE mytable.ctitle LIKE '%'+cname+'%' into cursor temp.
>This always creates a cursor with 0 records. The same code executed outside of the form from a .prg works fine. Could someone please tell me how to get it to work?

Is cursor temp already taken in your form?

You don't have a space after *.

Have you tried SELECT * FROM MYTABLE WHERE CTITLE=CNAME INTO CURSOR TEMP?