>>>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.
>
Private variables are visible in form's Load, so you may set your form's property to the private variable in the calling program in the form's Load.
Other solution would be to set up combo's RowSource in the code (form's Init) rather than in the property sheet.
If it's not broken, fix it until it is.
My Blog