Sylvian, this is what I whan to do but I am using SQL Server not VFP.
So you see it is not passable to do this in a View of SQL Server.
I did post this question in the SQL Server forum?
>If I understand correctly what you mean, use the question mark:
>
>
SELECT * FROM table WHERE field = ?m.cValue
>
>VFP will replace ?m.cValue with the value of that variable when opening the view and issuing a REQUERY().
>
>Is this what you're looking for?