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

Yep, that's why I tried both. Form property and a variable created in the INIT. Obviously I wasn't clear.

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

Great. I just created a global in the form's LOAD until someone comes up with better a solution.

>Tamar