In the rowsource of a combobox I have the following code:

SELECT descriptio, repertoire FROM pco WHERE pco.idper = thisform.cformid ORDER BY descriptio INTO CURSOR curFormul

and the where clause does not work: I get all the records.

If I hard code thisform.cformid (which holds the correct value) as follows:

SELECT descriptio, repertoire FROM pco WHERE pco.idper = "0000000003" ORDER BY descriptio INTO CURSOR curFormul

it works.

Does this mean that I cannot use a form variable in a combobox rowsource or should I do something different?

Thanks
Raymond