>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).
If it's not broken, fix it until it is.
My Blog