General information
Category:
Coding, syntax & commands
Title:
Form variable in combobox rowsource
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only