>>You can open your view with NODATA clause - and then it won't ask for parameters until the first requery(), which can happen much later in code.
>
>Hi Dragan,
>
>I find that there's an exception to that.
>
>Have you ever put a ?parameter in the join clause ? It will ask for a parameter when opened with NODATA
Try NOREQUERY as well. Not sure what it does, and the view I tried it on pulls from other parametrized views, so I'm not sure whether the ?parameter was in the join or in the where only. It's sort of hard to dig out on a sunny Saturday when I'm doing my taxes :).