On my form I used:

SELECT * ;
FROM fullpric;
WHERE catno = thisform.catno1.Value ;
INTO CURSOR mycursor

to create mycursor on the fly.

On the report you need to make sure there is no table in the data environment. The control source for the fields on the report are mycursor.fieldname