>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?

First, ThisForm.MyValue is a property, not a variable and you'd normally create it in the Form Designer.

Second, the form's Init runs after the combo has been initially populated.

Tamar