>It's not allowed to use "THISFORM.MyValue" in the SQL of a ComboBox RowSource. I thought if I created a variable in the form's INIT that would keep it in scope and I could use that in the SQL, but it's out of scope. I hate to use a global variable, but is that the best solution?

Too bad you would not see it:

Re: Form variable in combobox rowsource Thread #936474 Message #936538

Quote:

Set up the RowSOurce of the Combo box using code in the form's Init like so:

lcRowSOurce = [SELECT descriptio, repertoire FROM pco ]
lcRowSOurce = lcRowSource + [WHERE pco.idper = ( thisform.cformid ) ]
lcRowSOurce = lcRowSource + [ORDER BY descriptio INTO CURSOR curFormul]
Thisform.MyCombo.RowSOurce = lcRowSOurce
Thisform.MyCombo.Requery()