>#DEFINE ALL_LOC "(All)"
>
>lcColor = IIF(THISFORM.cboColors.VALUE = ALL_LOC, "", ALLTRIM(THISFORM.cboColors.VALUE))
>
>REQUERY("your_view")


It works when I change the variables by hand to "", but when i send
the value "" in the program I get a data type mismatch. (My key
values are integers). I cant see why it works one way
and not the other...