>>>Sonny, I've done this, but I put the form property into a variable, and call the parameterized view with the variable
>>>
>>>CREATE SQL VIEW "myView" AS
>>>SELECT * FROM myTable WHERE myTable.field1 LIKE ?MyVar
>>>
>>>Then MyVar = thisform.cCondWhere
>>>
>>>Sele MyView
>>>=requery()
>>>
>>>I've been using variables in both the WHERE and the SORT BY clauses with no problems.
>>>
>>>HTH
>>>Barbara
>>
>>Thanks for your response.
>>I want to parametrized the whole WHERE clause with a variable. I've tested many ways to do this but I didn't find one that works.
>>
>>SELECT * FROM myTable WHERE &whereClause
>
>Generally you need quotes around the macro for this...

Actually, I've got my anwser. I searched in the Microsoft Knowledge Base and I found that you cannot do this with Remote Views. You can just Parametrized each condition. We can't use Macro substitution in Remote views.

Thanks anyway