>>>>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
You're quite right -- I was thinking local...remote has to be standardized to be able to handle all types of different interfaces...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.