>>Hi Naomi,
>>
>>
>>SELECT - SQL has problem with corectly evaluating THIS and THISFORM.
>>Yes, you can use varibale, but the variable must be PUBLIC (visible for control on form).
>>
>>Or another solution...
>>
>>* cboDepartments::InteractiveChange
>>thisform.cboCategories.rowsource = "select * from csrCategories where department = SPACE(10) or department = '"+This.Value+"' into cursor csrCat"
>>thisform.cboCategories.Requery()
>>
>>
>>MartinaJ
>>
>Yes, I went with the same idea, but then we need to re-build the combo every time (which I did).
I don't use .rowsourcetype = 2 for combobox. I use .rowsourcetype = 0 always and I have not problem with rebuid combo for four levels.
MartinaJ