>>>HI!
>>>I am using parametrized view but the only thing I dont't understand is how can I set the parameters initially when the form is executed. I don't have any problem with REQUERY. Its just the initialization that asks me for an input value. I am wondering how can I assign a value prior to this.
>>>THANKS.
>>
>>One way is to set view in DataEnvironment with Cursor.NoDataOnLoad=.T. It will save you from initial prompting. Then in some method, e.g. Form.Init event you may set parameter value and then issue =Requery("MyView")
>
>That's what I do. Ed, I think you and I are pretty much on the same page about how to get to data. :)
Honestly, I rarely use local views :) (remote ones is another story).
Edward Pikman
Independent Consultant