>Hi nadya,
>
>It does work with the view designer. However you'll have to omit the question mark. (so &cWhere) and be sure the cWhere variable does not exists. I'm not sure what you mean by "use this view as part of database" though. all views are part of a database....
>
>Walter,
>
Is it changed when you do requery() ?

I have to try it...

It doesn't allow me to do it. I open ViewSQL, remove my where condition and put &cWhere instead of the whole where clause. It produces an error and reverts back to original filter. What can I do?

Thanks.