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

Christopher,

I don't know why it's not working with integers I haven't tested this situation. In SQL the wildcard % would work with both char and int data, not sure how to deal with this in FP.

Kim